CASE WHEN condition THEN value1 ELSE value2 ENDSQL Server's ISNULL():
value1 IS NULLISNULL(x,y) can be done this way:
CASE WHEN x IS NULL THEN y ELSE x END>i have tried to creat a remote view using iif() function but sqlserver doen't recognize this. how can i do it ? (i also tried it in sqlserver view designer but it was the same thing)