Assistance needed on query

Sims, John (CDC/CCHP/NCBDDD) (CTR) ayu8 at CDC.GOV
Mon May 14 12:59:52 CDT 2007


Hi Ruslan,

> 
> But you describe in fact this case:
> >>     SELECT expr as 'alias'
> 
> NOT 
> >>     select '' as 'alias'
> 
> First case works in Valentina also I believe.
> 
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information http://www.paradigmasoft.com
> 

Do you know if it would have work for him if he had used:

SELECT ' ' as 'alias' FROM myTable

Making sure he put a space between the quotes?  Or, is it possible to
use

SELECT NULL as 'alias' FROM myTable

Just trying to see what is possible.

Thanks!

-John



More information about the Valentina mailing list