using trim with SQL

Question

I've attempted to use trim() im my SQL statement but It throws an error saying its not a valid function.

This isnt the statement but this is the context im using it in.

<cfquery datasource="#datasources.DATADSN#">
INSERT INTO dbo.People (Christian)
<cfif IsDefined("FORM.Christian") AND #FORM.Christian# NEQ "">
trim('#FORM.Christian#')
<cfelse>
NULL
</cfif>
</cfquery>

If you cant use it at this point, where can you use it?

drforbin1970 · Accepted Answer

If you are just trying to trim leading/trailing whitespace,here is the correct syntax:INSERT INTO dbo.People (Christian)#Trim(FORM.Christian)#NULL

Anonymous · Answer

It looks like you're using SQL Server. SQL Server 2000doesn't have a unified trim function, you need to left andright-trim. Try LTrim ( Rtrim ('#FORM.Christian#')).

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.