RIGHT Returns the part of a character string starting a specified number of integer_expression characters from the right.Syntax RIGHT ( character_expression , integer_expression ) 同样的,从左开始获取 LEFT Returns the part of a character string starting at a specified number of characters from the left.Syntax LEFT ( character_expression , integer_expression )
select dd from table where right(rtrim(dd),1) = '3'
Returns the part of a character string starting a specified number of integer_expression characters from the right.Syntax
RIGHT ( character_expression , integer_expression ) 同样的,从左开始获取
LEFT
Returns the part of a character string starting at a specified number of characters from the left.Syntax
LEFT ( character_expression , integer_expression )
where right(rtrim(dd),1) = '3'