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]
