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]
