Okay, if all else fails, then create a duplicate table with one difference - a VARCHAR instead of a BLOB. Then keep them synchronised with triggers. Then base your search on the duplicate.
Paolo > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 11:02 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] sql help > > > I know and I really need to. > > > -----Original Message----- > > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > > Sent: 12 September 2002 11:08 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] sql help > > > > > > BTW, varchar supports 8000 chars, so don't use text unless > > you really need > > to, as it works completely different to varchar as it is a > > BLOB (no comments > > please Shaila). > > > > -----Original Message----- > > From: Rich Wild [mailto:[EMAIL PROTECTED]] > > Sent: 12 September 2002 10:29 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] sql help > > > > > > beautiful. cheers mate. > > > > > -----Original Message----- > > > From: Douglas Humphris [mailto:[EMAIL PROTECTED]] > > > Sent: 12 September 2002 10:39 > > > To: [EMAIL PROTECTED] > > > Subject: RE: [ cf-dev ] sql help > > > > > > > > > Rich, > > > > > > use DATALENGTH(a.content) to get the length... > > > > > > HTH > > > > > > Douglas > > > > > > -----Original Message----- > > > From: Rich Wild [mailto:[EMAIL PROTECTED]] > > > Sent: 12 September 2002 10:12 > > > To: '[EMAIL PROTECTED]' > > > Subject: [ cf-dev ] sql help > > > > > > > > > Can anyone help me with this, my brain is fuzzy after the 8 > > > or 9 pints from > > > last night's work's curry night. > > > > > > I have a table with a text column in it (SQL2000) > > > > > > I want to return a bit (1|0) indicating whether or not the > > > row has text in > > > it. The column either has text in it, or has no text in it > > > (but is never > > > NULL). > > > > > > I've tried using LEN, but apparently I can't use that with > > > text columns. > > > > > > I also tried > > > > > > contentlength = ( > > > IF a.content = '' > > > BEGIN > > > SELECT myvar = 0 > > > END > > > ELSE > > > BEGIN > > > SELECT myvar = 1 > > > END > > > ) > > > > > > but that wigs out also. > > > > > > I've also tried a CASE statement, but apparently you can't > > > use text columns > > > with WHEN. > > > > > > Alles in sy maai > > > > > > Rich > > > > > > > > > -- > > > ** 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] -- ** 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]
