>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
>>>