no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | howto:replace_nulls_with_blanks_in_sql_server [2011/12/19 21:33] (current) – created smark | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== How To Replace Nulls With Blanks In SQL Server ====== | ||
| + | < | ||
| + | UPDATE | ||
| + | table | ||
| + | SET | ||
| + | field = '' | ||
| + | WHERE | ||
| + | ISNULL(field, | ||
| + | </ | ||
| + | |||
| + | ISNULL checks if " | ||
