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
>