STR() gives whitespaces on the front of the variable you convert to string. It can be a good choise to convert decimal variables but not for Int ... ... <看更多>

SQL = return single string or integer from SQL query to a variable, Execute Scalar - return_one_row_from_sql.sql. ... <看更多>

... <看更多>

Unfortunately I cannot concatenate and integer and if I convert DP to a string then the query is invalid as the PLANNUMBER field is numeric whilst LOTNUMBER ... ... <看更多>