Check for Null Value in a Stored Procedure

Within a stored procedure use an IF STATEMENT to check a parameter for a NULL VALUE

if( @CustomFieldID is null)
begin
   print 'NULL VALUE - SKIP IT'
end
else
begin
 print 'PARAMETER HAS VALUE'

end