search in web site

[miladhatam]

hi
i want the sql script of search in a field of database
of course i've written this scipt but in Unicode search it dosen't
work
select * from Table1 where tex like '%" +
Request.QueryString["search"].ToString() + "%' or topic like '%" +
Request.QueryString["search"].ToString() + "%'
thanks

% in sql means match more than one word.

select * from Table1 where tex like '[%]" +
Request.QueryString["search"].ToString() + "[%]' or topic like '[%]" +
Request.QueryString["search"].ToString() + "[%]'

try it!

<mi********@gmail.com写入消�
news:11*********************@19g2000hsx.googlegrou ps.com...

hi
i want the sql script of search in a field of database
of course i've written this scipt but in Unicode search it dosen't
work
select * from Table1 where tex like '%" +
Request.QueryString["search"].ToString() + "%' or topic like '%" +
Request.QueryString["search"].ToString() + "%'
thanks

[rgparkins]

On Oct 5, 2:45 pm, "[e-mail]" <[e-mail]>
wrote:

hi
i want the sql script of search in a field of database
of course i've written this scipt but in Unicode search it dosen't
work
select * from Table1 where tex like '%" +
Request.QueryString["search"].ToString() + "%' or topic like '%" +
Request.QueryString["search"].ToString() + "%'

thanks

Have you tried to create a full text catalog on the field you wish to
search on, this may allow you unicode searches. You can create these
via enterprise manager on the database node, it is then just up to you
to implement the full text search on the programming side which is
very simple :)