Fabio,
Molto grazie (is that correct?) - anyway, thank's a bunch.
Although I'm not sure I understand the logic of it - why just 'E'?
Is that really the only one that will convert to numeric?
>>I tried:
>>
>>
>>Select DamageNo,Cast(RequisitionNo AS Integer) As RequisitionNo From
>>(Select DamageNo,
>> Case ISNUMERIC(DamageNo)
>> When 1 Then DamageNo
>> Else Null
>> End As RequisitionNo
>>from dbo.DamageInserts) T
>>
>>
>>The column DamageNo is of type varchar and contains values such as '1542A111','0455E204','104702'...
>>
>>Isnumeric filters out '1542A111' as not convertible, but leaves '0455E204' because it can can be converted to float, that is, a numeric.
>>
>>Which is all Isnumeric promises to determine.
>>
>>Since I've got a legacy table to convert, I need is something like
>>
>>
>>
>>
>>Select DamageNo,
>> Case Cast(DamageNo As Integer)
>> When
>> Else
>> End As RequisitionNo
>>from dbo.DamageInserts
>>
>>
>>Help is deeply appreciated.
>
>
>Select DamageNo,
> CAST(Case WHEN ISNUMERIC(REPLACE(DamageNo,'E','_'))=1 Then DamageNo End AS INTEGER) As RequisitionNo
>from dbo.DamageInserts
>
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)