> Because I sent my email before the 'datalength(column)' solution was > suggested and I did say a last resort.
ah ok, I got that email quite a bit after the datalength one. > I do repeat though that you are searching on a text column. I think we're talking semantics. I still say I'm not searching on the column. I'm selecting it. searching it would be WHERE datalength(column) > 0 or something. in my select statement I'm retrieving the size of the cell and in the case statement I select a 1 or a 0 depending on the outcome of the datalength. thats not searching. > -----Original Message----- > From: Paolo Piponi [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 11:51 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] sql help > > > 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] -- ** 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]
