Because I sent my email before the 'datalength(column)' solution was suggested and I did say a last resort.
I do repeat though that you are searching on a text column. Whether you are calculating the length or evaluating the value, you are still searching on the text column. Paolo > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 11:25 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] sql help > > > no, I'm not, I'm retrieving the size of the text contents, > not searching on > the contents. > > why would I want to go to the hassle of creating a duplicate > of the column > and storing it in a new table with triggers etc when > datalength(column) > works just fine? > > > -----Original Message----- > > From: Paolo Piponi [mailto:[EMAIL PROTECTED]] > > Sent: 12 September 2002 11:43 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] sql help > > > > > > > I'm not searching on the text, I'm just checking to see if > > > theres text in > > > there or not. > > > > > > > Yes, you are searching on text! > > > > Paolo > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
