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