Length () is used to calculate the length of a string, and the corresponding function in mssql is len ().

Nvl is a null substitution function. When it is judged that the parameter 1 is null, the output parameter 2 is replaced.

The corresponding function in mssql is isnull ().

Length (NVL(RZSJ,''))

Output the length of RZSJ column value. If it is empty, output the length of empty string (0).