SQL Server natively does not support regular expressions. One needs to use .net library and it is not great experience as you might have a database where sqlclr might not be enabled. Morever – nobody will give quick access to .net ide etc on that machine or you might not be familiar with .net , so can’t code up quick routine for the same. So when you are stuck like this as I was, where do you turn? You dig deep into the manual (implement RTFM).
SQL has following function
ASCII ( character_expression )
Returns – int –
Returns the ASCII code value of the leftmost character of a character expression.
This means one can run query like
ac_no ac ,
part_no part ,
lang = 1 and
(ascii(fm_name) not between 65 and 122) or
(ascii(rln_fm_nm) not between 65 and 122)
group by ac_no,part_no
order by ac_no, part_no asc