keyid test 161289462 valid 50578283 valid UGM49O3 valid I am using below query but still getting wrong results. Select keyid,CASE WHEN keyid like '^[A-Za-z]*%' THEN 'invalid' else 'valid' end as test from table I am expecting below keyid test 161289462 valid 50578283 valid UGM49O3 Invalid Appreciate your help in advance. Thanks ... View more