Solved

concat in sql server: I must do to concatenate the 3rd column...

Posted on 2011-02-24
1
505 Views
Last Modified: 2012-06-21
select s.ComexSecuenciaOperacion, sl.SecuenciaLeasing, s.ComexSecuenciaOperacion + sl.SecuenciaLeasing concat
            from solicitud s inner join solicitudleasing sl
                        on s.CodSolicitud = sl.CodSolicitud
concatenar.jpg
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 10

Accepted Solution

by:
dwe761 earned 250 total points
Comment Utility
select s.ComexSecuenciaOperacion, sl.SecuenciaLeasing, convert(varchar(20),s.ComexSecuenciaOperacion) + convert(varchar(20),sl.SecuenciaLeasing) as ConCat
            from solicitud s inner join solicitudleasing sl
                        on s.CodSolicitud = sl.CodSolicitud
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now