sql select problem?

SELECT
user_name|| " " || user_sname
FROM
users

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

Try this instead:

Code:

---

SELECT (user_name + ' ' + user_sname) FROM users

---

- petter