Dear all,

I have a field with String type. The format is like that e.g
12345a 23456b or 12345 . The last english character of the field is
optional. Now I need to determine whether the last english character
exist, if it exist, then I need to extract the last english character.
for example, if the field is 12345b, then the character extracted is b,
if the field is 12345c, then the character extracted is c, if the field
is 12345, then no character is extracted. How can I perform this task
in sql statement?

Thanks

Select Case When IsNumeric(Right(StringField, 1))=1Then ''
Else Right(StringField, 1)
From YourTable


-- rBYoung

Dear rBYoung,

IF I have two fields to select, can I write as follows:

select case....then ...else.., case...then..else..,
fieldsA from TableA

Thanks for your reply.