Re: Umm, almost embarrassed to ask this, but....

In article <34DB8723.410D@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >What's the best way to retrieve the value of a system variable, say >TODAY? Obviously, I can do: > >SELECT TODAY from table1 >where key='aaa'> >but I have to know that this will return a single row. How about a >general select statement that doesn't require detailed knowledge of a >table's data? > Why do you need to select it. Most languages have a way of getting the value. E.g. 4GL has the TODAY keyword. >Thanks > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK >neil.truby@chase.com -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care