convert money value to spaces

[ronaldmacdonald]

Hi

Is it possible to convert a money value to spaces?

e.g. 01 to " " (not the quotes but two spaces)

Can integers be converted as well?

Ron

 

[nigelrivett]

Not sure what you want

select space(len(convert(varchar(100),@val)))


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[SQLBill]

You can do it, but you can't keep it as MONEY or INT. You'll need to convert it to a string and then replace the value.

SELECT REPLACE((CONVERT(VARCHAR(2), money_column_value)), '01', ' ')


-SQLBill