sql ÅжÏ×Ö·û´®ÖÐÊÇ·ñº¬ÓÐÊý×ÖºÍ×Öĸ

ÅжÏÊÇ·ñº¬ÓÐ×Öĸ

select PATINDEX('%[A-Za-z]%', ¡®ads23432¡¯)=0

£¨Èç¹û´æÔÚ×Öĸ£¬½á¹û>1£©

ÅжÏÊÇ·ñº¬ÓÐÊý×Ö

PATINDEX('%[0-9]%', ¡®234sdf¡¯)=0

£¨Èç¹û´æÔÚÊý×Ö£¬½á¹û>1£©