在选择语句中联接2个字段 [英] Joining 2 fields in a select statement

问题描述

MS SQL SERVER-存储过程


SELECT AIDNO，
(ALOANUMBER + AIDNO)有条不紊
来自弗朗斯语

如何编码(ALOANUMBER + AIDNO)AS LOAM以修剪所有空格


谢谢

MS SQL SERVER - STORED PROCEDURE


SELECT AIDNO,
(ALOANUMBER + AIDNO) AS LOAM
FROM VLOANS

how do you code (ALOANUMBER + AIDNO) AS LOAM to trim all spaces


Thanks

推荐答案

您只需要修剪两个部分.

You just need to trim both pieces.

SELECT AIDNO, RTRIM(LTRIM(ALOANNUMBER)) + RTRIM(LTRIM(AIDNO)) AS LOAM
FROM VLOANS

要修剪空格，可以使用 LTRIM()和 RTRIM()函数
查看我最喜欢的Pinal Dave关于修剪的完整文章.
SQL SERVER – 2008 – TRIM()函数–用户定义的功能 [ ^ ]

示例:
用于单个字段修剪-

To trim spaces, you can make use of LTRIM() and RTRIM() functions
Check this complete article on trimming by my favorite, Pinal Dave.
SQL SERVER – 2008 – TRIM() Function – User Defined Function[^]

Example:
For individual field trimming-

SELECT AIDNO,
(LTRIM(RTRIM(ALOANUMBER))) + LTRIM(RTRIM(AIDNO))) AS LOAM
FROM VLOANS

对于修剪后的结果，

For the concatenated result trimming-

SELECT AIDNO,
LTRIM(RTRIM((ALOANUMBER + AIDNO))) AS LOAM
FROM VLOANS

希望对您有帮助:)

注意:对于SQL Server 2012/2014，存在一个函数 TRIM()，该函数执行相同的操作，而不是使用两个函数.

Hope, it helps :)

Note: For SQL Server 2012/2014, there is a function exists, TRIM() which does the same thing instead of using two functions.

这篇关于在选择语句中联接2个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！