Viewing 2 posts - 1 through 2 (of 2 total)
quote:this should do it: cast(left(annoying_column,patindex('%ed%',annoying_column) - 1) as integer)you can either cast the other column as an integer, or throw another cast...
quote:
this should do it:
cast(left(annoying_column,patindex('%ed%',annoying_column) - 1) as integer)
you can either cast the other column as an integer, or throw another cast...
July 25, 2003 at 9:21 am
#467103
you can either cast the other column as an integer, or throw another cast around this whole thing to get it back...
July 25, 2003 at 8:16 am
#467075