| Subject | Re: [firebird-support] SQL script for returning the length of a datafield |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2009-11-13T11:57:54Z |
> > If I want to varify of there are any stock codes that are not 16I'd go for:
> characters long, what script would I use?
> >
> > select stockcode
> > from stock
> > where??
>
> stockcode containing ' '
where char_length(stockcode) <> 16
Mark
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01