it would probably be about 4 or 5 columns. I'm really don't want to have to use a cursor if I don't have to. Running some tests using a sp...

Just gives a syntax error. Even doing this will give that error:

SELECT IsNumeric(ShipToNum)

From Pub.ShipTo

Where CustNum = 10

RGR'us, unfortunately isNumeric() doesn't seem to work.

Our ERP system actually uses a progress database but it's supposed to be SQL-92 compliant. Most functions work as they would in SQL...

unfortunately there isn't any type of consistency with the way the characters are stored.

so they could be 'hug1' '1hug' '1hu2g' etc...

Thank you very much Yelena. That was a big help to me.

I'm still trying to understand the new security in 2005.