Posted by Remco Groot Beumer on 05/21/05 13:24

Hello,

I'm making a view in SQL Server EM. In this view I want to generate a field
which combines 3 other fields simply together.
I have the fields: lngNumber (numeric), txtOpdrachtgever (string) and
txtAfdeling (string) which I want to combine (with a space between each
field). In Access reporting the string would be.
NameOutputField: lngNumber & " " & txtOpdrachtgever & " " & txtAfdeling
How does this work within SQL server. I get messages of datatype errors when
I use + or &. I don't now the syntaxis to convert fields.

So can anyone give a suggestion on how to make the above string and also
give a little bit information on the conversion of fields within views. I
didn't find it in the SQL help files.

Thanks,

Remco Groot beumer

• Next in forum: Announcement - GM SQL Query 2005
• Prev in forum: Re: Update question
• Thread view: Newbie: how to make a datatypeconversion in a view

[Reply to this message]