sql select problem?

[sa_keles]

SELECT
user_name|| " " || user_sname
FROM
users

i am trying to concat this two column but i has problem near the "|"
any idea?

[wildfrog]

Try this instead:

SELECT (user_name + ' ' + user_sname) FROM users

- petter