Subject SQL script for returning the length of a datafield
Author nvdheever
I have a stockcode field in the stock table which is a char type. Usually it is left padded with 0 and have 16 characters.

If I want to varify of there are any stock codes that are not 16 characters long, what script would I use?

select stockcode
from stock

Should I use a function to do this?