https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/8674.aspxTue, 03 Jan 2006 21:20:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:8674Matt Faus0https://www.infopathdev.com:443/forums/thread/8674.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=8674This could be done using code and an intermediate storage facility. You will have your original fields in one set of data and then use code to grab the the last n characters from the fields and write them into a new table. Then populate your drop-down with this "converted" table.<br /><br />Hope this helps!<br /><br />---------------<br />Matt Faus<br />InfoPath Dev Texas<br />https://www.infopathdev.com:443/forums/thread/5238.aspxTue, 03 Jan 2006 17:17:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5238tatopitta0https://www.infopathdev.com:443/forums/thread/5238.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5238Hi all,<br />is it possible to display in a dropdown list only the last n characters of a set of fields?Thank u again.