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