Multiple Selects into a Variable

[NiceArms]

I am trying to place a several SELECT CASE statements into a variable and I am not having much luck.

Example follows:

SELECT CASE WHEN LEN(Field1) <21 THEN field1 + SPACE(20 - LEN(field1 )) END,
CASE WHEN Field2 = 'X' THEN 'Y'
FROM Table1

Note: this query returns several records.

How do I get the information into the variable to that i can start "playing" with the data?

/Nice

 

[bborissov]

You can't. The variable always will get value from the last record in the recordset.
But why you need variable? you can use that query as a derived table in your main SELECT.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[NiceArms]

Thank you for confirming my thoughts.

believe it or not 10 minutes after posting this query I figured it out!

typical ay

/Nice