Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

CHARINDEX

  
   Database Forums (Home) -> MSEQ RSS
Next:  Creating an ODBC connection  
Author Message
Bryan

External


Since: Mar 07, 2006
Posts: 9



(Msg. 1) Posted: Fri Jul 13, 2007 7:40 am
Post subject: CHARINDEX
Archived from groups: microsoft>public>sqlserver>mseq (more info?)
I find that CHARINDEX does not seem to return the position of a matching
phrase when the token being searched contains punctuation after the phrase.

In other words CHARINDEX('Birthday', 'Hope you have a happy Birthday!', 0)
does NOT return the position of Birthday in the phrase!!

Please can anyone advise me on this.

Thanks
Bryan

 >> Stay informed about: CHARINDEX 
Back to top
Login to vote
Mohit K. Gupta

External


Since: Jun 29, 2007
Posts: 35



(Msg. 2) Posted: Fri Jul 13, 2007 8:12 am
Post subject: RE: CHARINDEX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I get 23 from both SQL 2000 SP4, and SQL 2005 SP2.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

 >> Stay informed about: CHARINDEX 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
using wildcards [ ] in REPLACE or CHARINDEX functions - I'm basically trying to replace non alpha characters of values in a couple columns, but would prefer to create a ud-function or have a function in my view do this for me rather than have to manually update every non-alpha character. I'm trying to do....

EXEC (select... ) problem Help! - How can I get this to work? declare @WkEmpID declare @sql varchar(1000) set @sql = 'select distinct @WkEmpID = EmpID from Employee' exec (@sql) Now this is a simplified version of a more comples query which is forcing me to use this method rather than...

Query returning multiple rows - Hi, I have a query that returns back rows that have multiple entries for a given UniqueID. I want the query to be expanded so that it then only returns 1 of the multiple rows based on the maximum date. Thefore, my return set looks like this: ..

Having a stored procedure copy tables & also preserve inde.. - Hello, I created a stored procedure that renames a table to OLD_xxxxx and replaces that table with another (copy) that resides on a different database. I pull the tablename names through the use of a cursor table and construct a SELECT INTO statement a...

GROUP BY's on 3 tables in one SELECT? - Hi there, I'd like to ask you for help with following: having 3 tables: T1 (Person_ID, Product_ID, Costs) T2 (Person_ID, Product_ID, Balancies) T3 (Product_ID, Product_Type) I have simple GROUP BY query: SELECT T1.Person_ID, T1.Product_ID, MAX(Costs)..
   Database Forums (Home) -> MSEQ All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]