Get certain characters

[antgaudi]

How can I get only Phoenix from Phoenix, AZ?
I have other cities and states on the query but in the same format.

I've tried substr(a.air_location,-4,4) but I get ", AZ", the opposite of what I need.

Thanks.

[skhanal]

try

substr(a.air_location,1,7)

[antgaudi]

I have other cities so the 7 might cut of other names..thanks for the input though.

[SDas]

antgaudi, I don't know Oracle SQL functions and syntax but it should have this feature.

Use a function to find the location in a string of a specified character. In your case, that would be a comma. This should return the number of the position of the comma (8 in the Phoenix, AZ example) in the text string. Embed this with a - 1 in the substring statement. Something like this:

SUBSTR(A.AIR_LOCATION, 1, LOCATE(',', A.AIR_LOCATION) -1)

[antgaudi]

I found something similar to that. Thanks.