Re: asterisk as data

You can use the escape character also (\\), i.e: CONSTRUCT BY NAME alfa ON table_name.* LET query1="SELECT * FROM table_name WHERE alfa AND ", "column_name=","\\"","*","\\"" note that you have to use the escape character twice. or you can use its ASCII value : ASCII(42) LET query1="SELECT * FROM table_name WHERE alfa AND ", "column_name=","\\"",ASCII(42),"\\"" --- "Richard E. Hassler" <Hassler.1@osu.edu> escribi': > Using Informix SE 7.2. > > In a perform screen query I can do \\* in a column to > determine if any of > the rows have an asterisk as the only data in a > column. > > In SQL I can do 'where column_name = *' to determine > if any of the rows > have an asterisk as the only data in a column. > > I can't figure out how to do this in 4gl when using > the construct > statement. Can anyone give me a clue? ===== ______________________________________ Luis Carlos D'az Otero ALCANOS DE COLOMBIA S.A. E.S.P Carrera 9 # 7-25 Neiva (Huila (Colombia)) __________________________________________________ Do You Yahoo!? Yahoo! Mail ' Free email you can access from anywhere! http://mail.yahoo.com/