Comments by lohithrao

lohithrao 15-Oct-13 4:44am View

Thanks for the reply PadamAgarwal ji and sorry for the delay.
In my data base i have
1)stJohns
2)st.Peterburg
3)saintAnns
In my Auto-complete box i have an option of sending 3 characters to search from database.I wanted to search 'stJohns' but the user passing 'st.' to get stJohns, As he is thinking that stjohns might be saved as st.johns. This is context.

lohithrao 8-Oct-13 5:06am View

Thanks for Reply Padam Agarwal but that doesn't solve my requirement, as when i will pass

Declare @val varchar(100) = 'st.'
Then it should return all the 3 names

lohithrao 7-Oct-13 10:38am View

yeah %st.%, it is returning only st. names

Comments by lohithrao (Top 3 by date)