re:error :column mismatch

panic · Post by **panic** » Mon Sep 26, 2005 11:57 am

if column name (varchar) datatype then column name (integer) datatype
else integer (datatype).

i wrote in the transformer stage

If lo.custid Matches ("1970" Or "1971") Then in_data.value Else 0

is it the correct way or not.i have doubt on the quotation marks.
if not suggestions plzz.
thanks

kcbland · Post by **kcbland** » Mon Sep 26, 2005 2:41 pm

Go back to your original post and read the answer supplied there.

ETIQUETTE: Do NOT multiple post the same question.

ketfos · Post by **ketfos** » Mon Sep 26, 2005 2:55 pm

Hi,
I think the correct way of doing is

If lo.custid Matches "1970" : char(253) : "1971" Then in_data.value else 0

OR

If lo.custid Matches 1970 : char(253) : 1971 Then in_data.value else 0

Ketfos