<me@privacy.net> wrote in message
news:uti723-p9v.ln1@mercury.tcm.vispa.net.uk...
> hi,
>
> how would I query my table to return only the records where the field
> 'mobile' has a valid mobile telephone number.
>
> Valid being.. begining 07 and being 11 characters in length.
>
> many thanks,
>
> Dave
>
something like:

select mobile from table where mobile like '07%' and length(mobile) = 11;

John