×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
COALESCE will pick the size of the larger field as the filed size. CAST
forces it to be CHAR(10):
CAST( SubStr( COALESCE(A.UDFBVALUE,' '), 1, 10) as CHAR(10)) as SCHEDB,
"TheBorg" wrote in message
news:mailman.8240.1379433148.9013.midrange-l@xxxxxxxxxxxx...
CAST the resulting value as CHAR(10)
-sjl
"Jeff Young" wrote in message
news:mailman.8239.1379432863.9013.midrange-l@xxxxxxxxxxxx...
All,
I have an SQL View where I am selecting only part of a character field
using the SUBSTR function in a CTE, then using the derived field in a Group
By for the final select.
Part of the code is: SubStr( COALESCE(A.UDFBVALUE,' '), 1, 10) SCHEDB,
My problem is that when I look at the file definition, the field SCHEDB is
defined as :
Data Field Buffer
Field Type Length Length
SCHEDB CHAR 40 42
What do I need to do to get this field defined as CHAR 10?
Thanks,
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
