UFN_CODETABLE_GETID

                create function dbo.UFN_CODETABLE_GETID 
                (
                    @NAME nvarchar(100)
                )
                returns uniqueidentifier
                with execute as caller
                as
                begin
                    return (select ID from dbo.CODETABLECATALOG where DBTABLENAME = @NAME);
                end