Jump to content
Sign in to follow this  

Using Charindex to get left of a charcter

Recommended Posts

I have a field called subjects  and the data looks like this ALJ Diane Davis - WCF

I am trying to get all the data to left of the "-"

I am using Advantage SQL which I am new too.  IF i was using T-SQL i would be using something like this:  left(appts.subject,charindex('-',appts.subject)


Thanks in advance 

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this