Try any of the following

Select * from mytable where Right ( myfiled,6)=myEnteredvalue
Select * from mytable where Right (Alltrim( myfiled,6)=myEnteredvalue

If myfiled is Numeric , than you need to use STR() also.

Hope That Helps



I need to do a SQL command which will search on a field which has 15 characters but the user will enter the last six digits only. So, basically, the first 9 characters are not entered and I must find the record matching the last six digits. I usually do the opposite with the % character at the end combined with a LIKE. Anyone has an example on this type of search?