Hi, Can anyone tell me the best way to replicate the val() coldfusion function in MS SQL Server 7?
I need to convert NULL values to 0, and although I can do the IF val IS NULL then SET val = 0 I just wondered if there was a neater way to do it. I have tried CAST(val as FLOAT) and convert, but neither worked. Thanks in advance Andy Hall.
