Perfect, thanks!
>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
>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people