Trimming Data

[renee35]

I have a field that looks similar to this:

F1 - Test
F02 - Test
.
.
F15.25 - Test

I am trying to get the data in the front before the "-". cannot use the trim function because the amount to be trimmed is not the same and when I use the "charindex function it returns a 1,0, or null. My charindex looks something like this:

'MILESTONE'=left(charindex('',S_XX.NAME,-1),

I am missing something or is more needed?

Any help is greatly appreciated..


Thanks a bunch!!

-T

 

[paulkeys]

You maybe could use the split function within reporting services itself (perhaps in a customer function), that would split based on the '-'

 

[dhulbert]

Try

left('F15.25 - Test', patindex('%-%','F15.25 - Test')-1)

Shoudl work fine.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)