Re: [sqr-users] Wildcards with Evaluate Statements

[Don Mellen <donm@ontko.com>]

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