Hi I want to insert char (A) in second index where code start with 's'
Input
s1
s2
s34
Require output
sA1
sA2
sA34
Update T1
set code = ??
where code like 's%'
views:
8answers:
3
A:
Try this:
UPDATE myTable
SET myColumn = 'sA' + RIGHT(myColumn, LEN(myColumn)-1)
WHERE LEFT(LOWER(myColumn), 1) = 's'
p.campbell
2010-08-26 05:00:52
all colums set to sA where condition satisfied
NETQuestion
2010-08-26 05:13:27
@NETQuestion: feel free to give upvotes to all who helped answer your question!
p.campbell
2010-08-26 05:18:05
A:
Update T1
set code = 'sA' + SUBSTRING(code, 2, LEN(code)-1 )
where code like 's%'
x2
2010-08-26 05:02:30
+2
A:
Update MyTable
Set Code = Stuff(Code, 2, 0, 'A')
Where Code Like 's%'
Thomas
2010-08-26 05:15:29