September 22, 2010 at 1:18 pm
I want to return everything in a certain value before the first '('.
LEFT(esl.text,FINDSTRING(esl.text, "(", 1)) as Text
When I execute the code I get the error "'FINDSTRING' is not a recognized built-in function name."
What? According to MSDN, it exists - http://msdn.microsoft.com/en-us/library/ms141748%28v=SQL.90%29.aspx
Am I doing something wrong?
September 22, 2010 at 1:26 pm
sorry, should have searched the forums before posting....
The correct syntax for what I'm trying to accomplish:
LEFT(esl.text,CHARINDEX('(',esl.text)-1) as Text
September 22, 2010 at 1:27 pm
The page you posted a reference to is for SSIS. Are you trying to use this in SSIS or T-SQL?
If you're trying to do this in T-SQL then may I suggest you take a look at CharIndex instead.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2010 at 1:40 pm
DrStrangepork (9/22/2010)
sorry, should have searched the forums before posting....The correct syntax for what I'm trying to accomplish:
LEFT(esl.text,CHARINDEX('(',esl.text)-1) as Text
WOW
Your timing was something else. Happy you found the solution.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply