Add a character to a field

[Ed75]

I'm sure this is a stupid question but I've never done it before.

What I want to do is add a leading zero to all of the items in a field that start with a 9. Can anyone lend me a hand please?

 

[GShen]

RIGHT(100 + fieldname,2)

Remember when... everything worked and there was a reason for it?

 

[tc3596]

try this...

update table
set field = case when left(ltrim(field), 1) = '9' then replicate('0', 1) + field
else cus_name end

...if your field is an integer, you'll need to wrap field with convert(varchar, field). If your intention is to only select data, obviously use select vs update.

Hope this helps.