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]
