Re: subscripting in select statement

Try this: Select [fields] from table where (Character_Field[1,1]||Character_Field[3,5]||Character_Field[7,9]||Character _Field[11,14])=valiable || joins two string values : 'TE'||'ST' returns 'TEST' Character_Field[2,3] returns string from position 2 to 3: 'TEST'[2,3] returns 'ES' I hope this will work ... bye Peter Austin Castro wrote in message <70lmdb$pdi$1@news.xmission.com>... > >Hi, > I'm having a problem with the following select statement. > > select [fields] > from table > where character_field[1,3,6,12] = variable > > the character field is of length 14 and is in the following format > 0-800-123-4567. The variable is 8001234567. I want to match the records >with the > variable. I get an error saying something about subscripting. Is >there anyway to work > around this? Please help. > > austin