RE: [sqr-users] Wildcards with Evaluate Statements

["Lindquist, Maria" <mlindqui@uwc.edu>]

I just tried this before you sent this message and that's how I'm going
to do it. Thanks anyways for the suggestions!

-----Original Message-----
From: Don Mellen [mailto:donm@ontko.com] 
Sent: Friday, January 03, 2003 11:32 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Wildcards with Evaluate Statements


On Fri, 3 Jan 2003, Lindquist, Maria wrote:

> Is there any way to use Wildcards with Evaluate-When statements in 
> SQR?

Nope.  The "evaluate" command and the "when" both on;y accept values,
not expressions.
  
> I wanted to find class sections that begin with a certain letter and 
> do something. For example:

If the above is what you want to do, you could say....
   let $begins_with = substr(&CLSFEE2.CLASS_SECTION, 1, 1)
   evaluate $begins_with
      when = 'B'
         .....
      when = 'D'
         .....

If you want to do checks like below, for "has a 'B' in it" and  "starts
with 'D'", then seperate "if" statements would probably be best.

> EVALUATE &CLSFEE2.CLASS_SECTION
>  
>   When = '%B%'         
>       ....         
>   When = 'D%'   
>       ....
>  
> etc............
>  
> 
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
> Maria K Lindquist
> mlindqui@uwc.edu
> IS Programmer/Analyst - Business Office
> University of Wisconsin Colleges
> 780 Regent St, PO Box 8680, Madison, WI  53708-8680
> Phone: 608.265.2677 / Fax: 608.265.5770
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
> 
>  
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
> 

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users