Ouch....I guess those Microweenies can't even write an isNumeric function that works....thanks for pointing this out Adam...

This was the correct answer:

if (@var LIKE REPLICATE('[0-Z]', LEN(@var)))

print 'yes'

else

print 'no'

The correct answer, in my opinion, is this:

Declare @var as varchar(100)

Set @var = '12312ASD435ASDah4ddASD123123'

If...

Send a salesman to PM, for what?  SQL Server could never handle that amount of data...ever.  Call Oracle.

comments is a key word in oracle....