When working with NULL, you’ll often find yourself wanting to replace these “missing” values, with something else. Just use ISNULL to do

Read More
Replace Missing Values in your Queries using ISNULL

The SQL ISNUMERIC function checks the input expression for a valid numeric data type. It returns 1 if the input value is

Read More
SQL ISNUMERIC Function (Transact SQL)

Use the SQL ISNULL function to evaluate the input expression for a NULL value. If it is NULL, then ISNULL replaces it

Read More
SQL ISNULL Function (Transact SQL)

Use the SQL CONVERT function to change an input expression from one data type into another specified data type. For example, a

Read More
SQL CONVERT Function (Transact SQL)

The SQL CAST function converts an input expression of one data type into another data type.  Description Data types of values often

Read More
SQL CAST Function (Transact SQL)

Knowing when to use the SQL COALESCE function is a lifesaver when you’re dealing with NULL. As you know, NULL is a

Read More
SQL COALESCE Function and NULL