[thelist] SQL Server: How Can I Convert VARCHAR to INT?

[rudy]

> BTW, if anyone does have a SQL server trick to do this,
> I would still be interested in hearing it.

not yet, james, i'm still thumbing through my couple of dog-eared
sql/server books (one o' them is 4.5) looking for functions that might
help, and so far, nothin'

what about a stored proc?  with looping at your disposal, you can look at
each character of the field and discard the ones that aren't numbers, and
*then* do a cast...

of course, if this is a one-shot deal, do it outside the database as
anthony suggested...


rudy