Subject | Correct syntax of a view, please. |
---|---|
Author | Erik De Laet |
Post date | 2003-10-09T13:12:26Z |
Hi,
Can anyone point me in the direction to the correct syntax of a view
like:
select aNr,aName,aText ,
---> (1 if aNr mod 10 = 0, 0 otherwise) <---- this line please
from MyTable
Thanks in advance,
--
Erik De Laet - E.De.L.Com bvba
- The Software bridge to the user! -
Web site: www.edelcom.be - www.edelcom.com
Can anyone point me in the direction to the correct syntax of a view
like:
select aNr,aName,aText ,
---> (1 if aNr mod 10 = 0, 0 otherwise) <---- this line please
from MyTable
Thanks in advance,
--
Erik De Laet - E.De.L.Com bvba
- The Software bridge to the user! -
Web site: www.edelcom.be - www.edelcom.com