Select correct record from table 1

[liark]

I'm passing accross url.name which is a concatanation of two fields in a database table (forename, surname)

Please, how can I select that record from the table?

SELECT * from person
where 'per_forename per_surname' EQ #url.name#

Liark

 

[TruthInSatire]

What db are you using the syntax may be a little different

SELECT * from person
where per_forename & ' ' & per_surname EQ #url.name#

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[TruthInSatire]

oops sorry.

SELECT * from person
where per_forename & ' ' & per_surname = '#url.name#'

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[liark]

It's just an Access database.

Thanks for your help.

Liark