I don't think any of the answers work because of the punctuation between 9 and A

I'd try

IF (@var LIKE replicate('[0-9A-Za-z]', len(@var))

PRINT yes

ELSE

PRINT 'no'

set nocount on

declare @MyTable table (

 id int identity(1,1),

 numA int,

 numB int

)

Insert into @MyTable values(1,2)

Insert into @MyTable values(1,3)

Insert into @MyTable values(2,2)

Select id from @mytable

Group by id, numA, numB

Having (numA = 1) And...

You got any space saving or performance improvement with this scheme?  Do you have less code to maintain?

Any chance you'll be locking everyone out of all lookup values while you're maintaining...

What are you doing with these lookups?  Are you modelling business processes and/or enforcing referential integrity?  Or are you populating drop downs?

You simply cannot sensibly combine all objects (OO sense, but not...

The fix is to reregister the tasks. Open a new package and register as custom tasks msmdtsp.dll and msmdtsm.dll.

Darren Green had the answer in

http://groups.google.com/groups?selm=erw1PLNeCHA.3596%40tkmsftngp08&oe=UTF-8&output=gplain

This article is a good start.

There are even better reasons not to use Hungarian Notation. I don't care about the data type of a column often enough....