DataType Imported in FM

[BIsrik]

Hi,

I have imported a product table in model. The product table contains product id and product name. The product name column is of varchar(100) datatype in the table definition. When imported in FM, data type is shown as character with precision as 100.

When viewed in cognos viewer, the product name values are added with extra spaces, so that the total length of the value displayed is 100.

Please help in solving this.

Srik

[DustPanMan]

Srik,

Is the datatype greyed out so that you can't change it back to a vchar?

Best regards,

Dustin

[BIsrik]

Yes, this grey out and i am not able to change to any other datatype.

Srik

[kart78]

You could use Trim function to remove Trailing spaces.

[BIsrik]

I had tried doing that but noticed that the trim function is filtering some records... ???

Srik

[kart78]

http://www.itjungle.com/fhg/fhg101106-story02.html

[Gopinath]

Try

TRIM( CAST( [Data Item] as varchar(100)))