Getting first character 1

[Gatorajc]

This is an easy one. I know I did it before just cant find it. I have a column with the following data.

I-w654534-rer
2-e564654-hkh
1-e546544-dre

I want to just get the first character left of the first -.

Thanks in advance.

AJ


If at first you do not succeed, cheat!

 

[Gatorajc]

Sorry a little to vague. I want to query on the character just left of the first -



AJ


If at first you do not succeed, cheat!

 

[bdreed35]

Try this:

Left('I-w654534-rer',CHARINDEX('-','I-w654534-rer')-1)

~Brian

 

[Gatorajc]

I found the answer I was looking for already.

substring(TempID,1,1)

Thanks anyway.

AJ


If at first you do not succeed, cheat!

 

[Gatorajc]

After further review. I went with your suggestion Brian.

Thanks

AJ


If at first you do not succeed, cheat!