pcsoft.us.windevCopyright 2026, PC SOFT5 Sep 2017 19:23:00 Z5 Sep 2017 17:41:00 ZHi All I want to SELECT DISTINCT MyField FROM ... but I want to treat all MyField the same if they have the same value regardless if they have trailing spaces i.e. "SMITH" is the same as "SMITH ". I tried using NoSpace() but that does not return any results at all then. Any suggestions? Thanks30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62552/read.awp5 Sep 2017 19:23:00 ZPeter & Paulo Thanks very much. Will use those functions instead of NOSPACE()https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62552/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62552/read.awp[WD] - Select fieldsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62549/read.awp5 Sep 2017 18:14:00 ZTo remove the spaces in both ends use TRIM In the left LTRIM In the right RTRIMhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62549/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62549/read.awp[WD] - Select fieldsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62548/read.awp5 Sep 2017 18:02:00 ZHi JP, SELECT DISTINCT LTRIM(YourField) FROM... Cheers, Peter Holemanshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62548/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62542-select-fields-62548/read.awp[WD] - Select fields