update to match 2 different column of data

[alternative]

let for an example:
<cfset word1="hello">
<cfset word2="world!">

and inside database on of the column id=20
record like below:
ID-------NAME
20, helloworld!

on this situation, i wanna update the record on something,
but how i gonna to match it together?

my code is like below,
<cfquery datasource="#db#">
update table set xxxxxx
where [word1+word2] = NAME
</cfquery>

anyone can help me on this?

[Dan Bracuk]

where name = '#word1##word2#'

Originally posted by: alternative
let for an example:
<cfset word1="hello">
<cfset word2="world!">

and inside database on of the column id=20
record like below:
ID-------NAME
20, helloworld!

on this situation, i wanna update the record on something,
but how i gonna to match it together?

my code is like below,
<cfquery datasource="#db#">
update table set xxxxxx
where [word1+word2] = NAME
</cfquery>

anyone can help me on this?

[alternative]

how about 'hello - world!"?

how i gonna plus both word together in sql?

[alternative]

how about we make it reversely.

1 word <cfset word="Hello - world !">

and we have firstname, lastname in database

[Dan Bracuk]

where name = '#word1# - #word2#'

Originally posted by: alternative
how about 'hello - world!"?

how i gonna plus both word together in sql?