enNa try paneenghala :lol:Quote:
Originally Posted by Raikkonen
r u SQL server Developer?? I am one :D
Printable View
enNa try paneenghala :lol:Quote:
Originally Posted by Raikkonen
r u SQL server Developer?? I am one :D
ileeng :lol: sorry..
i'm more into network/web programming. :)
just got the mcse cert.. but not very familiar with sql server.
Oh cool. so u can do java scripting and .net programming right :) , if i have any doubts i shall ask, cos .Net & sql server are highly integrated , they work very closley :DQuote:
Originally Posted by Raikkonen
cool..
i haven't worked with java for some years now. i can do the applets etc.. almost in advanced stage.
ya. i'm working in net environment. :thumbsup:
Raiks
aama neenga enna 'Diamon' smuggling busniess panrEla?? Diamon hubber nu title kudithirukuranga :lol2:
Hi
I have SQL table with a customer table in SQL server , having columns (name, lastname)
the last name contains values like (o'corner, o'brian) how would i search for these records iusingT-SQL
Select * from customers
where lastname like 'O'coner%'
it does not work cause of the single quote bewteen O and C... any way round it?
Raiks??
Add another apostrophe. Something like,
Code:select * from customers
where lastname like 'O''CORNER%'
Paramasivan,
This is for you :
http://blog.sqlauthority.com/2008/02...racter-string/
To add to Nerd's post, if you're going to call the sql from a webpage etc, this kind of concatenation could pose sql-injection threat and this link gives a solution for that :
http://it.toolbox.com/wiki/index.php...SQL_queries%3F
Danks Nerd :)Quote:
Originally Posted by Nerd