Calling All Sql Experts

[DATASTAGE999]

oka table lo e column insert chesi, dhani replace with comma cheyali (carriage return box shape lo undhi)

Input:

name
fg(carriage return) __________nffff

replace:

fg,__________nffff


help plzzz

[innovative]

Be specific about environment..

Madhyalo underscores aa avi (i mean aa blank space enti)

Try replace function.
Replace(string1, string2, string3)
In string1, find where string2 occurs, and replace it with string3.

[Terminator II]

[DATASTAGE999]

[quote name='innovative' timestamp='1344055383' post='1302255470']
Be specific about environment..

Madhyalo underscores aa avi (i mean aa blank space enti)

Try replace function.
Replace(string1, string2, string3)
In string1, find where string2 occurs, and replace it with string3.
[/quote]


yes bhayya avi underscores and nenu google chesthe yedho char(13)+char(10) e function use cheyamanadu. kani wrk avvadam ledhu .

[ChampakDas]

[img]http://lh5.ggpht.com/-vhy7turw1dY/TwKNbRvJ65I/AAAAAAAAF0A/tbJCldCgTGE/s150/Mahi-30.gif[/img] be clear...ina this is what I infer

For adding a column you need to alter the table first ALTER TABLE yourtablenam ADD columnname datatype
And for replacing you need to update the column with your own defined value. You can do that by

Update tablename
set yourcolumn = REPLACE(yourcolumn,'fg(carriage return) __________nffff',fg,__________nffff)
where blah blah

[innovative]

[quote name='DATASTAGE999' timestamp='1344056662' post='1302255542']


yes [s][b]bhayya[/b][/s] avi underscores and nenu google chesthe yedho char(13)+char(10) e function use cheyamanadu. kani wrk avvadam ledhu .
[/quote]



If i understand ur question correctly ,

UPDATE Table SET Column = REPLACE (Column , CHAR(13), ' ,') WHERE ................


And ee rendu gurthupettuko ..


CHAR(10) = New Line
CHAR(13) = Carriage Return