> > > 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??
> >
> > stockcode containing ' '
>
> I'd go for:
> where char_length(stockcode) <> 16

BTW: This only works if stockcode is varchar, for char you would need char_length(trim(stockcode)) <> 16.

Mark
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/chbrowser