[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Concatenation

Laura, try this it should work.

Let $WhereCL = ' AND EFFDT Between ' || $prior_year_begin||' And
'||$prior_year_end ||''''

-ag
At 05:12 PM 12/13/01 -0800, you wrote:
>Hello everyone!
>
>Does anyone know why this doesn't work?
>
>Let $WhereCL = ' AND EFFDT Between ''' || $prior_year_begin And
>$prior_year_end ||''''
>
>Thanks in advance!
>
>Laura.
>_______________________
>Laura López
>Extension:    1018


---------------------------------------------------------------------------------------------------
Antonio G. Guiza                                        mailto:aguiza@pcc.edu
Programmer/Analyst                                                (503)
977-4395
Portland Community College  SY CC-224             fax (503) 977-4987
ITS Systems Development                                 http://www.pcc.edu
---------------------------------------------------------------------------------------------------