Generalhttps://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)Re: Replace in queryhttps://www.infopathdev.com:443/forums/thread/10376.aspxWed, 23 Aug 2006 06:57:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10376Patrick Halstead0https://www.infopathdev.com:443/forums/thread/10376.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10376Hi GW,<br />I have absolutely no idea. Sorry for such a clueless response, but just wanted you to know that I read your post .... :)<br />Replace in queryhttps://www.infopathdev.com:443/forums/thread/5800.aspxMon, 21 Aug 2006 19:59:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5800gw2kbust0https://www.infopathdev.com:443/forums/thread/5800.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5800I'm using a query like this:<br /><br />SELECT Replace(ProjectDescription, 'CUE - ', '') FROM Projects<br /><br />This query works in Access but won't run in my C# code. I'm trying to fill a dataset but it doesn't like this for some reason. Does anyone know why? Thanks for your help.