converting field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Job - 29 Jul 2005 16:39 GMT

I have a table that has a units column that is varchar because some of the
units have text in them. I'm attempting to update the units into a new
field that is called Fxd_Units.

Update Tbl_MyTable
Set Fxd_Units = Cast(TxnUnits as Numeric)
Where TxnUnits not like '%M%'

This throws the error converting error.

Any help is appreciated.

Cheers,

Job

Reply to this Message

Job - 29 Jul 2005 17:38 GMT

This works,

Update Tbl_MyTable
Set Fxd_Units = Cast(TxnUnits as Numeric)
Where IsNumeric(TxnUnits)=1

>I have a table that has a units column that is varchar because some of the
>units have text in them. I'm attempting to update the units into a new
[quoted text clipped - 11 lines]
>
> Job

Reply to this Message

Louis Davidson - 29 Jul 2005 18:19 GMT

Look at (and then post if needed :) the results of:

select txtUnits
from tbl_mytable
where isNumeric(txtUnits) =0

You might need to use REPLACE () to get rid of some fun

Signature

----------------------------------------------------------------------------
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP

> This works,
>
[quoted text clipped - 17 lines]
>>
>> Job

Reply to this Message