How to trim a string from a space

Question

I have a field like

BestStreet 123/56

and I want to get

BestStreet

I've tried:

LEFT(sd.UliceCP, CHARINDEX(' ', sd.UliceCP)-1)

And why doesn't your code work? It should work on the example you have given. — Gordon Linoff, Jul 03 '17 at 12:23
Possible duplicate of [SQL Substring Issue](https://stackoverflow.com/questions/24879450/sql-substring-issue) — Ken White, Jul 03 '17 at 12:25

score 5 · Accepted Answer · answered Jul 03 '17 at 12:24

5

You may want to add a space, just in case one does not exist.

For example: Notice the sd.UliceCP+' '

LEFT(sd.UliceCP, CHARINDEX(' ', sd.UliceCP+' ')-1)

answered Jul 03 '17 at 12:24

John Cappelletti

score 0 · Answer 2 · 2017-07-03T14:39:03.423

0

Using Substring Also we can get the same

SELECT SUBSTRING(sd.UliceCP,0,CHARINDEX(' ',sd.UliceCP))

edited Jul 03 '17 at 14:39

answered Jul 03 '17 at 12:35

2 Answers2