Sorry hit the send button quickly. I have just used a similar qualification
for validating email addresses...
((NOT ('Email' LIKE "[EMAIL PROTECTED]")) OR (NOT ('Email' LIKE "%.%")))
I guess you can use a similar qualification.
On 4/23/08, Mahesh <[EMAIL PROTECTED]> wrote:
>
> Hello Everyone
>
> I have a character field for inputting the name of a person. I am trying
> to write an active link that will throw an error message if that field has
> special characters (anything apart from A - Z). What kind of a qualification
> do I need to put in RUN IF.
>
> Environment: ARS 7, SQL Server 2005, Custom Built HD
>
> Appreciate your time and help in advance.
>
> Thanks
> Mike
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"