IT Professionals

[PARAMASHIVAN]

i don't have any servers installed at my home..

i will try to read and understand this at office

enNa try paneenghala

r u SQL server Developer?? I am one

[Raikkonen]

ileeng sorry..

i'm more into network/web programming.

just got the mcse cert.. but not very familiar with sql server.

[PARAMASHIVAN]

ileeng 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

[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.

[PARAMASHIVAN]

Raiks

aama neenga enna 'Diamon' smuggling busniess panrEla?? Diamon hubber nu title kudithirukuranga

[PARAMASHIVAN]

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??

[Nerd]

Add another apostrophe. Something like,

select * from customers
where lastname like 'O''CORNER%'

[app_engine]

Paramasivan,
This is for you :
http://blog.sqlauthority.com/2008/02...racter-string/

[app_engine]

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

[PARAMASHIVAN]

Add another apostrophe. Something like,

select * from customers
where lastname like 'O''CORNER%'

Danks Nerd