问题描述:
我在写一USE_REGISTER store procedure,要判断字符的大小写,请问有合适的函数么?
---------------------------------------------------------------
回答:
Declare @p varchar(10)
Declare @v varchar(10)
set @v='NIPSAN'
set @p='Nipsan'
IF CAST(@v as varbinary)=CAST(@p as varbinary)
print '相等'
else
print '不等'