Member Avatar for preeti anand

HOW can append two different datatype coulmn in singal column?

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

Hello,

You are looking for the cast and convert commands. For example:

SELECT TextID AS ID
FROM W1
UNION
SELECT CAST(NumericID As VARCHAR(20)) AS ID
FROM W2

Or, if you like CONVERT():

CONVERT(VARCHAR(20), NumericID)
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.