Re: Fast SQL Question


"Filter911" <filtermedialtd@xxxxxxxxx> wrote:


> If I use like and I want to find all emails in hotmail that have at
> least one char before the '@' and after the '.'
> Is this the right command

> where EmailAddress like '%_@xxxxxxxxx%'


Remove the space between "%" and "@hotmail", the same at the other
end.


Paul...


--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.
.

Relevant Pages

  • fast SQL question about LIKE command
    ... If I use like and I want to find all emails in hotmail that have at ... least one char before the '@' and after the '.' ... where EmailAddress like '_%@xxxxxxxxx%' (underscore placed ...
    (comp.databases)
  • Fast SQL Question
    ... If I use like and I want to find all emails in hotmail that have at ... least one char before the '@' and after the '.' ... Prev by Date: ...
    (comp.databases.theory)
  • Re: Fast SQL Question
    ... Paul wrote: ... >> If I use like and I want to find all emails in hotmail that have at ... time analysing and attempting to help, ...
    (comp.databases.theory)
  • Re: All my hotmail is gone
    ... selecting all your emails in Outlook Express and then dragging them to the ... Hotmail inbox. ... By the way, Outlook Express and Entourage use the same email file format, so ...
    (microsoft.public.mac.office.entourage)
  • Re: [Full-Disclosure] Full-Disclosure] Hotmail & Passport (.NET Accounts) Vulnerability
    ... > There is a very serious and stupid vulnerability or badcoding in Hotmail / ... > Emails, Privacy Issues, ...
    (Full-Disclosure)