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

asked Jan 28 '10 at 06:54 AM in Default

Radha S
23 ● 2 ● 3 ● 3

(comments are locked)

0 answers:

Be the first one to answer this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Jan 28 '10 at 06:54 AM

Seen: 468 times

Last Updated: Jan 28 '10 at 07:29 AM