Hi I have written some sql and have added a case when to remove nulls
but it doesn't seem to be working is there a website where I can
check
the syntax or can anyone provide me with some help?

On Jun 19, 4:51*am, James Brown <james.brown... (AT) googlemail (DOT) com> wrote:
Hi James -

You can actually check syntax right inside of SQL Server Management
Studio or SQL Query Analyzer (in 2000). You click the checkmark
instead of the execute. It sounds like your syntax is technically
speaking correct if the query is executing so feel free to reply here
with the actual syntax you are using and an idea of what the table
creation script looks like and what the data in the table looks like.

HTH
Mike Walsh
www.straightpathsql.com/blog