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-06 : 10:34:19
|
| HI GUYS ,please can you help me with this..I have a string where in i need to find out the location of 1st space after £ sign in note.The Note is " Fund app fee - admin and val fee processed for £285 Admin fee - £120 auth code: 613760 Val fee - £165 auth code: 632294"correct answer is 4..Iit should consider 1st occurence of £ |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-06 : 11:21:09
|
| look at charindex and patindex functions._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
SPACE IN A STRING