Code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:FixedLineProvisioningConnectionString %>"
        SelectCommand="SELECT trim(tblFixedLine_order_summary.bid_model) FROM tblFixedLine_order_summary WHERE (tblFixedLine_order_summary.fllog_ref = @fllog_ref)">
I'm getting 'trim' is not a recognized built-in function name.

I need to trim it as when i display the data from tblFixedLine_order_summary.bid_model in my detailsview its a hyperlink to the file and the link doesnt work becuase of trailing %20's.

Thanks in advance for your help and advice.

Steve