question

Radha S avatar image
Radha S asked

Full text search in sql server 2005

hi,

the qusery select * from tablename where contains(tablename., '"001"')

is not returning any value but,

select * from tablename where contains(tablename., '"BDJ"')

is working fine.

Is SQL server 2005 is supporting search with contains keyword with leading wildcard?

Please help me

Thanks

sql-server-2005full-text
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.