ezytime,

I appreciate your deprecation of the the misappropriation of 'depreciation'!

Sorry to be the first pedant, but the syntax for the Immediate If function is IIf() NOT iff()

Hi Charu,

Bit of a SQL Server "newbie" myself, but from years of Access work, how about using InStr(column_name, " ") to find your space, with a combination of Left() and...