Hello Every one.
I am trying to search data from table using like with wild cards.
Below is the sample.
select consignername from tbl_packet where consignername like '%i s p%'
which is giving me desired result.
"I S P"
But however if i write my query as below
select consignername from tbl_packet where consignername like '%isp%'
Datatype of the column is nvarchar(100)
I have a procedure for searching in which i have to implement it, if it is possible.
Any Help would be appreciated
Thanks And Regards