SQL 字符串操作[获取'(') 左边的所有文本] [英] SQL string manipulation [Get all text left of '(']

问题描述

我有一些看起来像这样的数据:

I have some data which looks like so:

SourceOfBooking
----------------
Company1 (Foo)
Company2 (Bar)
Company3 (Foo1)
Company4 (Foo2)

我希望对此进行转换，因此我的数据仅显示:

I am looking to transform this, so my data only displays:

SourceOfBooking
----------------
Company1
Company2
Company3
Company4

我试过了:

LEFT(SourceOfBooking, CHARINDEX(';', SourceOfBooking) )

运气不好.

我确定我遗漏了一些非常简单的东西......有人愿意启发吗?

I'm sure I'm missing something incredibly simple... Anyone care to enlighten?

KR，詹姆斯.

推荐答案

我觉得你刚才放错了字符

I think you've just put a wrong character

case
    when CHARINDEX('(', SourceOfBooking) > 0 then
        rtrim(left(SourceOfBooking, CHARINDEX('(', SourceOfBooking) - 1))
    else
        SourceOfBooking
end

这篇关于SQL 字符串操作[获取'(') 左边的所有文本]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！