SMS Report queries - concatenating text fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello;

I was wondering what the syntax is using the CAST operator to
concatenate two text fields together. Here's an example of the query
I have right now;

select v_R_User.Name0 | ' , ' | v_R_User.Windows_NT_Domain0 AS
Information
FROM v_R_User

I know the query makes no sense, I'm just using this as an example to
find the correct syntax to bring the two fields together. If anyone
knows the correct synax to do this I would really appreciate the
information. Thank you.

-Dan

.

Relevant Pages

  • RE: EXISTS reserved word in FROM clause
    ... we make a good pair because I know Access SQL ... from what you described the query syntax that I ... >The subquery should return the records: ...
    (microsoft.public.access.queries)
  • Re: Exclusive Form
    ... You're using the syntax for an UPDATE query, ... "'", dbFailOnError ... I created a new table called FormLock with one field named ...
    (microsoft.public.access.formscoding)
  • Re: Bizarre subquery syntax problem
    ... With Access, the official syntax for a subquery always requires an alias, so ... SELECT p.AS UID, p.Firstname AS Firstname, p.Lastname AS Lastname, ... I am seeing bizarre problems with a subquery. ... core query runs fine- ...
    (microsoft.public.access.queries)
  • Re: PSP
    ... I'd be interested in your opinions on syntax of PSP... ... Furthermore, if a query fails, it does not ... > look like it allows the programmer to directly mix the Prolog and HTML. ... Another downside is that predicates cannot be ...
    (comp.lang.prolog)
  • RE: sending a query to access in asp.net
    ... Microsoft Online Support ... | Regarding on the ACCESS sql query statement issue you mentioned, ... | Dim param As New OleDb.OleDbParameter ... While the ACCESS database use '*' as the widchar for like syntax, ...
    (microsoft.public.dotnet.framework.aspnet)