>Perfect, thanks!

No problem, Kevin ... glad I could help. =)

~~Bonnie


>
>
>
>
>>Kevin,
>>
>>Try something a little different ... here's how we do it:
>>

>>IF NOT EXISTS(SELECT * FROM systypes WHERE name LIKE 'udt_fdid')
>>EXEC sp_addtype udt_fdid, 'CHAR(5)', 'NULL'
>>

>>
>>~~Bonnie
>>
>>
>>>I'm trying to write a small proc to create data types. The OBJECT_ID is
>>>returning NULL even though the id exists. What am I doing wrong here?
>>>
>>>

>>>USE db_bmdata
>>>GO
>>>IF OBJECT_ID ('SSN') IS NOT NULL
>>>  BEGIN
>>>    DROP TYPE SSN
>>>  END
>>>
>>>GO
>>>
>>>CREATE TYPE SSN	FROM VARCHAR(11) NOT NULL
>>>