Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pamit_1982
Starting Member
13 Posts |
 Posted - 2007-08-02 : 09:20:39
|
| Hi ineed to implement a case for a specific statement such that when (notetext = 'Fund app fee - admin and val fee processed for £285 Admin fee - £120 auth code: 613760 Val fee - £165 auth code: 632294')=4 else charindex(' ', substring(notetext, charindex('£', notetext)+1, 50)) as 'Space'how is it possible ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-02 : 09:44:22
|
quote:
Originally posted by pamit_1982
Hi ineed to implement a case for a specific statement such that when (notetext = 'Fund app fee - admin and val fee processed for £285 Admin fee - £120 auth code: 613760 Val fee - £165 auth code: 632294')=4 else charindex(' ', substring(notetext, charindex('£', notetext)+1, 50)) as 'Space'how is it possible ?
Can't tell by your post.Please rephrase and tell us what you have and what you want.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Space 44