Posts Tagged NullIf

replace field value using isNull and NullIf

Posted by Le Kevin in Database on May 28, 2008

select IsNull(Nullif(ifFieldValue1qual0, 0), ReplacewithFieldValue2)

also, in MS Sql 2005, use NewID() to get random recordset such as:

select top 3 * from someTable Order By NewID()

Share|

,

No Comments