Integer Comparison to Character Field 1

[gkrenton]

Yes I'm in over my head yet again.
I have a table with item numbers (integer) & UPC/SKU codes. The UPC/Sku code record is a Character field. Each item has a SKU number that begins with the item number & following record information. However there are also non-related UPC codes within the same table for the same item.
What I want to do yet what I want to dois create a view with only those UPC/Sku fields that start (match) the the first 5 digits of the UPC field.
But the syntax elludes me -
item like %upc_code% doesn't work
item like [item]% also doesn't work.

I'm thinking it's due to the data type 'mismatch' but seems like there should be a way to do this 'relation'.

Any suggestions?

Thanks
Gina

 

[PHV]

Something like this ?
item=upc_code[1,5]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gkrenton]

Yup that does it. And I think I'm about at the end of gathering the data that I need so I shouldn't make a post again for a few days.

thanks

-Gina