i wasn't planning on making any comments Russ :) ROFL
At 11:08 12/09/2002, you wrote: >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] Shaila Man IT Systems Administrator MediaTel Ltd 84-86 Regent Street London W1B 5AJ Tel: +44(0)20 7439 7575 Fax: +44(0)20 7734 0940 MediaTel Group - The essential solution to complete media efficiency. www.mediatelinteractive.co.uk www.mediatelgroup.co.uk www.MediaTel.co.uk This message is for the named recipient's use only and may contain confidential or privileged information. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Email communications are not secure and therefore the MediaTel Group does not accept liability for any errors or omissions in the contents of this message which arise as a result of email transmission. MediaTel reserves the right to monitor all email communications through its networks. Any views expressed by an individual in this email do not necessarily reflect the views of the MediaTel Group. -- ** 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]
