escape characters

Hot Topic

Cumulative aggregation over time
INSERT INTO as SELECT with ORDER BY
Help on report subscription
reference member in user hierarchy
Plase HELP ! SQL ERROR =>> An I/O error occurred while receiving the TDS prelogin response.
IE7 and SSRS Document Map
Remove all reports ( not data sources) from reports server
Syntax error
Send email -OnError event
Persistent communication session inside sqlclr proc?

SQL Server

sql server agent service failure
Track Login
Replication Configuration Helper (Id buy it!)
Reporting Services 2000 - Printing Hangs
In 2000 is it possible to list second parameter based on the first parameter selection
Sorting Data having months
Cannot Connect to SSAS using Reporting Services 2005
INNER JOIN between a CLR-TVF and a table returns no rows
DTS Permissions
How can we check the language by which functions, stored-procedures, and triggers are written in SQL Server 2005?

escape characters

Hi,

I need to insert this command into a table, but I can't because.

insert XXX

set column1 = isnull(Title,'') +

case when (case when title is null then 1 else 0 end) = 1 then '' else ' ' end

+ isnull(Last_name,'') +

case when (case when First_name is null then 1 else 0 end) = 1 then '' else ' ' end

+ isnull(First_name,'') +

case when (case when Middle_initial is null then 1 else 0 end)= 1 then '' else ' ' +

isnull(Middle_initial,'') END

I don't know how to use escape sequence, I need insert just once

thanks




Answer this question

escape characters

  • claudioe

    What excatly do you want to achieve

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • sdaemon

    I want to insert this command into column:

    insert tableXXX

    set columnZZZ= ' stuff + '' + stuff ' ' + stuff + '1'...'

    so I can select this column

    select columnZZZ from tableXXX

    I can get

    stuff + '' + stuff ' ' + stuff + '1'

    cheers



  • Dietz

    like this

    Insert into tableXXX values(''' stuff + '''' + stuff '' '' + stuff + ''1''...''')

    Add extra single quote for every quote appears in the string
  • escape characters
Answer this question