Member Avatar for madcloud

Hi all!!

Is there a way to return 2 cells merged in one? For example take the followng table:

| A | B | C |
|abc | def| etc |

and from this do a "SELECT A, B FROM table WHERE C='etc'" but instead of getting two values "abc" and "def", get one value "abcdef". It is important to do this from the query and not programmatically because the result is stored directly on a recordset.

Thanks in advance

GK

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by redsa
Member Avatar for redsa

Yes, simply doing a query like this:
SELECT A + B FROM table WHERE C='etc'

example:
SELECT 'abc' + 'def' AS sqlConcat

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.