Archives of the TeradataForum

Message Posted: Mon, 30 Jun 2003 @ 21:04:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

If two consecutive strings are given with blank are separator, they are treated as if they are concatenated. This works fine with SELECT statement but not with in the view.

for example:

sel * from t11 where j in ('1', '2' '3');

works as if you have given as

sel * from t11 where j in ('1', '23');

I have opened an incident with NCR and they are looking in to this problem. A DR82600 is opened to address this problem.

If you correct the view to have ',' between the strings, it should work fine. I have pasted small portion of view below.......

                              END)     AS Voice_Overage_Chrg_Amt
--
                          ,SUM(CASE WHEN P.PRODUCT_TYPE_CD IS NULL
                                     AND BSCH.CHARGE_CLASSIFICATION_CD
IN('104','204','304','404','504','604'  ==========> ',' is missing between 604 and 704
'704','804')

thanks,

	<Prev	Next>		<<First	<Prev	Next>	Last>>