We have data in a table that looks as follows:
RN00123450
LPN097777771
ARRT1190
RT0023334
(lots more with different starting letters)
We would like to get just the character portion of the string in a separate field so we get the following in a separate field in our query:
RN
LPN
ARRT
RT...
