Posted by Nik on 05/26/05 01:14

Select convert(varchar(30),lngNumber) +' ' + txtOpdrachtgever +' ' +
txtAfdeling + ' ' from tbl

"Remco Groot Beumer" <nospam@nospam.com> wrote in message
news:d6n28q$acb$1@news1.zwoll1.ov.home.nl...
> 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: Re: Creating a DB by restore - problems
• Prev in forum: Creating a DB by restore - problems
• Thread view: Re: Newbie: how to make a datatypeconversion in a view

[Reply to this message]