Select those in a column that meets character count criteria

[TRafati]

Hey, I know this is probably a simple thing to do, but I couldn't find it anywhere on the web so hopefully someone here can help.

I have a column of UPC codes which are a bunch of #'s. I need to find the ones that have more than or less than 12 characters.

Thanks

 

[pdx_man]

Check out the Len function in Access Help.

Select UPC_Code From YourTable Where Len(UPC_Code) <> 12

 

[gandnt]

Thank you for this post, after searching the internet for quite some time this solved my problem!!