Skip to Content
0
Former Member
Mar 21, 2021 at 07:25 PM

select with last two char

48 Views Last edit Mar 21, 2021 at 07:43 PM 3 rev

Hi all,

I want to write a cod for a new field of generic datasource in cmod. I should use select and one of conditions is last two characters of usnam field. I have to select values from table, with condition of USNAM field's last two characters. IF last two characters of USNAM field equel to 'MT' , 'TN' or 'SH', i will bring them in table which used in Loop. Length of USNAM char is 12 and some example for usnam values: 1234MT, 123MT etc. How can i write this select? Could you please help me about the issue?

Thanks.