Find fist character if its '-' and replace space

[kccoolrocks]

Hi,

need to find the fist character if its '-' and replace space in the derived column.


thanks,
ab

 

[fredericofonseca]

sure - look at the substring, replace, conditional and concatenate function - all of them available on the derived column window so easy for you to play with them until you get the desired result

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[SQLBill]

I'd suggest using CHARINDEX to see if the first character is a - and if it is, use REPLACE to change it.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875