Re: [GENERAL] Calculated update

2012-03-12 Thread Bret Stern
On Mon, 2012-03-12 at 17:39 -0700, Bosco Rama wrote: > Bret Stern wrote: > > > > trying to update a varchar numeric string column > > by converting it to int, adding a numeric value and insert it back > > as a varchar > > > > Having trouble with cast > > I assume you are doing an update as oppos

Re: [GENERAL] Calculated update

2012-03-12 Thread Bosco Rama
Bret Stern wrote: > > trying to update a varchar numeric string column > by converting it to int, adding a numeric value and insert it back > as a varchar > > Having trouble with cast I assume you are doing an update as opposed to an insert. You use both above (and both numeric and int as well)

Re: [GENERAL] Calculated update

2012-03-12 Thread Rob Sargent
On 03/12/2012 06:28 PM, Bret Stern wrote: trying to update a varchar numeric string column by converting it to int, adding a numeric value and insert it back as a varchar Having trouble with cast Possibly having trouble with two casts: one from string to int, one from int to string? You sql