Viewing 7 posts - 1 through 7 (of 7 total)
you guys/gals (sorry cant tell =) are completely right! i went under EM, looked under objects and there it was..two objects with 2 different owners! good catch ppl, now i...
May 28, 2003 at 10:42 am
Hi 5409045121009,
I tried the function you mentioned, and modified it a little so that it gave me the whole string and it worked.
CREATE FUNCTION MyStrip1(@v varchar(50)) RETURNS Varchar(50) AS...
May 16, 2003 at 8:48 am
ooh ok, but i need every single character so trimming off the FRI wouldnt work.
still have to try the other method above..keep ya posted..thx
May 15, 2003 at 3:17 pm
And no need to restart SQL services as well?
May 14, 2003 at 9:41 am
Thanks winash! I actually just modified it a little since it captured the first '-' in the result set:
Select Substring(email,charindex('-',email)+1,Charindex('-',email,Charindex('-',email)+1)-charindex('-',email)-1)
from matttest
That removes both '-' from the results..thanks again!
May 13, 2003 at 12:14 pm
I did but the problem with that is that it also requires a length and as you can see from the two sets above, the length will vary..unless there is...
May 13, 2003 at 10:32 am
What program is this that allowed you to install sqlagent.exe as a service?
May 12, 2003 at 3:20 pm
Viewing 7 posts - 1 through 7 (of 7 total)