eh? I'm not searching on the text, I'm just checking to see if theres text in there or not.
the reason I have to use text is because of the amount of text in there - it really is quite large. I know I can't use DISTINCT either, as well as some other functions, but thats ok, because I don't need to use them in this instance. > -----Original Message----- > From: Paolo Piponi [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 11:32 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] sql help > > > 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] > -- ** 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]
