Hi, people,

I have a SQL statment as record source of a DATA Control. I'm trying to insert a space between 2 fields, using this SQL:

If I use:
SELECT GroupID, GroupCode & GroupDescri AS Expr1
FROM Grupos
ORDER BY GroupCode WITH OWNERACCESS OPTION;
it works,

but if I use
SELECT GroupID, GroupCode & " " & GroupDescri AS Expr1
FROM Grupos
ORDER BY GroupCode WITH OWNERACCESS OPTION;
it returns a error messages (too few parameters, expect 1)

I've already tried to use str(GroupCode), cause GroupCode is a numeric field:
SELECT GroupID, str(GroupCode) & " " & GroupDescri AS Expr1
FROM Grupos
ORDER BY GroupCode WITH OWNERACCESS OPTION;
Same error

If I use:
SELECT GroupID, GroupCode & " " & 'GroupDescri' AS Expr1
FROM Grupos
ORDER BY GroupCode WITH OWNERACCESS OPTION;
same error.

What I am doing wrong?

Thanks in advance,
Roselene