Remove Hyphen from Field in MSSQL2005

[only412c]

I am trying to remove Hyphen and only report the number from field, how best to do so?
Example
Loinc_Cd Result needed
4548-4 45484
13457-7 134577
718-7 7187
2857-1 28571
2514-8 25148

Thanks in advance for you help.

 

[jbenson001]

select REPLACE(loinc_CD, '-','')

 

[Chopstik]

You could just use the REPLACE function in SQL. This will just replace it with an empty string but you can do it however you wish.

SELECT REPLACE(Loinc_Cd, '-', '')

------------------------------------------------------------------------------------------------------------------------
Reason and free inquiry are the only effectual agents against error; they are the natural enemies of error and of error only.

Thomas Jefferson

http://lessthandot.com

 

[only412c]

Thank for all and quick response. Sorry to bother, should have known better to use replace.