Query a field with spaces in it

[Frec]

I'm currently trying to run an update on a field in an Access database.

<CFSET LINENUM=LINENUM+1>
<CFQUERY NAme="UpdateRecords" DATASOURCE="CFACCESS">
UPDATE tbl1 SET FIELD3='NumberFormat(LINENUM, '00') WHERE Field0='L' AND
Field1='A B C D E F G'
</CFQUERY>

The data in Field1 has spaces in it. How can have the SELECT statement read
the correct data with the spaces. I tried the TRIM function but it didn't work
for me.

i.e TRIM('A B C D E F G')

Thanks.

Thanks,
Doug

[jdeline]

For openers, you need # around your NumberFormat( ) function: '#NumberFormat( )#'. What are you trying to filter on Field1? Could you provide an example of the data in Field1?

[Frec]

The data in field1 looks like the following:

'AB 123 061301AB 244 0106 101'

I'm going to try copy it from the field and paste it into my code. This may
keep the format. Maybe I don't a function.