Need Query for Searching Name from database.
-
i need a query for checkin a name whether it exists or not in database,, am storing firstname nd lastname in seperate columns. bt if i enter a first name only in textbox i need to display all names(firstname+lastname) ,starting from the entered first name PLZ HELP... Waiting 4 reply...
-
i need a query for checkin a name whether it exists or not in database,, am storing firstname nd lastname in seperate columns. bt if i enter a first name only in textbox i need to display all names(firstname+lastname) ,starting from the entered first name PLZ HELP... Waiting 4 reply...
Hi Mithun, Please try this. Hope it will help you.
if exists(select ID from Tablename where nameFirst like '%Your TextBox Value%') select nameFirst + SPACE(1) + nameLast As Name from Tablename where nameFirst like '%Your TextBox Value%'Keep Smiling :)
-
Hi Mithun, Please try this. Hope it will help you.
if exists(select ID from Tablename where nameFirst like '%Your TextBox Value%') select nameFirst + SPACE(1) + nameLast As Name from Tablename where nameFirst like '%Your TextBox Value%'Keep Smiling :)
Thank u Boss its Workin nw... :-D bt am passing the name as a parameter where cand_fname like @cand_fname its nt wrking bt if give as cand_fname like 'mith' this works so how change that
-
Thank u Boss its Workin nw... :-D bt am passing the name as a parameter where cand_fname like @cand_fname its nt wrking bt if give as cand_fname like 'mith' this works so how change that
k i got that ive changed to where cand_fname like '%'+@cand_fname+'%' thnk u..... :-D