Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Tue, Feb 21 2006 5:49 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Is there a way in sql of getting the length of a table stuffed into a memo field? I've tried LENGTH() and they're all 18 bytes Roy Lambert
Tue, Feb 21 2006 12:39 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Is there a way in sql of getting the length of a table stuffed into a memo field? I've tried LENGTH() and they're all 18 bytes >> Are you storing NULLs (#0) in the memo field ? If so, then LENGTH() won't work. -- Tim Young Elevate Software www.elevatesoft.com
Tue, Feb 21 2006 1:17 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim ><< Is there a way in sql of getting the length of a table stuffed into a >memo field? I've tried LENGTH() and they're all 18 bytes >> > >Are you storing NULLs (#0) in the memo field ? If so, then LENGTH() won't >work. I'm putting a table which also has a memo field with documents in it ... so probably somewhere along the line yes. Roy Lambert