How can I remove the last char ONLY if it is Capital V, otherwise, do not nothing.
Please see the results below. Thank you in advance.
DECLARE @cx VARCHAR(40)
SET @cx = 'testV' -- 'testd'
SELECT LEN(@cx)
SELECT LEFT(@cx, LEN(@cx) - 1)
select ASCII('V')
-- Result want:
test
testd