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, 2010 at 06:54 AM in Default

Radha S
23 ● 3 ● 3 ● 5

(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

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

asked: Jan 28, 2010 at 06:54 AM

Seen: 788 times

Last Updated: Jan 28, 2010 at 07:29 AM