Re: TEXT datatype?

Jim Kistler (kistler@an.hp.com) wrote: : I understand that I can't do a "query" on a TEXT datatype column, but : does this mean I can't test it in any way for an entry? : I'm writing a report for which a TEXT field might be empty and I would : like to note this fact with appropriate logic but can't find any test : on the column that will work with I-SQL. What about "WHERE LENGTH(textcol)=0"? (RTFM: 2-63T@4.1, 2-53T@5.0, 2-64T@6.0, 2-63T@7.1) : I can, of course, always print the column and accept a blank entry some : of the time ........can I deal with this in 4GL? Same thing should work. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.