Trying to write like regular expression in SQL select/update staements to get the values that look like any of these [“H6P.5“,“Z3C.10“,“D1V.1222“] where
1. the first character is an upper or lower case letter
2. followed by anything in between then a period
3. followed by matching the any set of repeating numbers, i.e. 12+ matches 122, 1222, and so on.
I tried this
select * from table1 WHERE ID LIKE '[A-Za-z]%.[0-9]%', but it also gets the values like H6P.5H, D1V.1JJ
I also tried this LIKE '[A-Za-z]%.[0-9]#', '[A-Za-z]%.[0-9]+', '[A-Za-z]%.[0-9]@', '[A-Za-z]%.[0-9]*' but won't get any values.