masking partof data element

[nfldbunker]

hi

i have a report which has a code and name in one column. i want to show the code but hide the nameportionof this data element. what is the best way to hide this

regards

bunker

[HalfBloodPrince]

Can you show some example of records in that data items .

[nfldbunker]

column 1   column 2    column 3
0124john  location      condition
4256bill
9788fred

should be

0124
4256
9788

[MFGF]

Do you always want the first four characters of the item? If so, add a query calculation with the following expression

substring([Your Item],1,4)

Cheers!

MF.

[HalfBloodPrince]

Am completely  agree with MF, for substring([column],1,4). Just for a change you can try this function of DB2

left ([name],4)  for achieving the same.

Thanks

[blom0344]

Am completely  agree with MF, for substring([column],1,4). Just for a change you can try this function of DB2

left ([name],4)  for achieving the same.

Thanks

That should only work with native functions enabled in the package and working against a DB2 database.
substring basically exists for all major RDBMS which makes is a more logical choice..