my tables are not static

[omphilesithole]

i have a lookup field that is calling the id and description concatinating the two as reportid so i need to substring/cut the length of the description cos it makes the dropdown very long and the table became so missed up the alignment? how can i cut the length of the of the description to display only 10 charactors

IF( CHAR_LENGTH(`crimereport1`.`id`) || CHAR_LENGTH(`crimereport1`.`description`), CONCAT_WS('', `crimereport1`.`id`, '.', `crimereport1`.`description`), '') as 'reportid

please help

[Satya Kavala]

Hi,
First of all you have to know that from where the description is coming to display there you may use the substring function.