| Subject | SQL script for returning the length of a datafield |
|---|---|
| Author | nvdheever |
| Post date | 2009-11-13T09:43:51Z |
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
where??
Should I use a function to do this?
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
where??
Should I use a function to do this?