Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all
Need help, somehow i am getting field on layout different from original data.
How can i show the exact field?
Do you want to preserve the exact number of leading zeroes? Then do this:
LOAD text(Field) As Field,
Length;
SQL SELECT
Len(..... rest of your SQL expression ....
;
try it once in text object
by using same expression
=len(INVENCOLORID)
Try num(Field, '0000')
Hi Dima,
Paste the code above the sql statement.
Load *,
Num(Field) as New;
Num' is not a recognized built-in function name.
SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'Num' is not a recognized built-in function name.
SQL SELECT
len(INVENTCOLORID) as Length,
INVENTCOLORID as Field,
Num(INVENTCOLORID) as New
FROM
Try this:
Tab1:
SQL SELECT
len(INVENTCOLORID) as length,
INVENTCOLORID as Field
from "DNA_PROD".dbo.NAOTMOBILEITEMS;
noconcatenate
Tab2:
Load length,
text(Field) as Field
resident Tab1;
Drop tab Tab1;
Do you want to preserve the exact number of leading zeroes? Then do this:
LOAD text(Field) As Field,
Length;
SQL SELECT
Len(..... rest of your SQL expression ....
;
still the same