Both the functions are used to show/assign different value if the parameter is null. select isnull(null,'test'),coalesce(null,'test') But there are diiferences between the two isnull() is sql server specific The datatype/length of the result depends on...