Hi CarKnee,
quote:
The only cases that have letters are "ed". It is roughly 200 records out of 200,000 that have letters in them.
in this case, you might take a look at PATINDEX in BOL to extract 'ed' and then CONVERT or CAST to int.
Sorry, I haven't got the time to figure out, Maybe someone else could do this!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]