Re: asterisk as data

--- "Richard E. Hassler" <Hassler.1@osu.edu> > wrote: >Evidently I'm doing something wrong since I don't get any responces to >my questions. Am I using bad tone, incomplete information, stupid >questions? Maybe it's the way you're spelling responses..... There is no such thing as a stupid question. Which is a really stupid statement when you think about it. Anyhow... >I would never have put an asterisk in a column as data but >my users have and now they want to query on it (they have also used a # >and + signs as data but I haven't got to that yet. > >If I query for a * using \\* in the 4gl data screen the construct >statement changes it to matches * which is a wild-card query for records >having something in the column whereas I just want the columns that have >an * as the data. Since this is only in one column, strip that one out of the construct and handle it by itself. That way you can test for your funky character(s) and add the appropriate AND statement to the end of your QBE construct. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net