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

[James Aylard]

Ryan,

> Yep, SQL is better...

    Hmm. This looks promising. One thing I now realize I made as clear as
mud in my original post was the part about discarding unneeded data. What I
meant (though I didn't clearly state) was that in those fields that contain
non-numeric data, I would still like to keep the numeric portion of the
data; I can discard the non-numeric portion. For instance, say I have the
value "250 PSIG" -- I want to keep the 250, but I can discard the " PSIG"
portion.
    Looks like a job for regular expressions which, afaik, SQL Server
doesn't support. Still thinking from within my little box, is there a
straightforward way to do that, as well?
    Thanks. (And thanks Rudy and Joshua for your feedback, as well.)

James