How can I insert into db in uppercase

[jsungmin]

hey there.
really need ur help.. my problem is I want to insert all value into db in uppercase

this is my code..

<cfquery name="insrt_srvy" datasource="#ds#">
INSERT INTO SURVEY_HEADER (REF_NO)
VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#ref_no#">)
</cfquery>

before this I put the uppercase around the value..
like this..

<cfquery name="insrt_srvy" datasource="#ds#">
INSERT INTO SURVEY_HEADER (REF_NO)
VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value=(Upper("#ref_no#"))>)
</cfquery>

but I got an error.
Can anyone help me please..
thanks in advance :)

[acoder]

Try:

value="#upper(ref_no)#"