Secondary Navigation. 1  Active Duty Dental Care. 2  Guard/Reserve Dental Care. 3  TRICARE Dental Program. 4  TRICARE Retiree Dental Program. 5  Enrolling in the TRICARE Retiree Dental Program. Costs. 6  Dental Benefits for Survivors. 7  Find a Dentist.
â¢ Although char and varchar are character data fields, char is a fixed length data field and varchar is a variable size data field. â¢ Char can store only fixed size non-Unicode string characters, but varchar can store variable sizes of strings.
Re: db2-- Decimal to Varchar without leading zeros. When you convert it to char it will have leading zeros infront of the decimal. So, using the trim will not remove those zeros cos it wud not have any trailing space. when you convert decimall to character you will not get trailing spaces instead you will get zeros in form of the number.