April 9, 2003 at 3:02 pm
Hi there, We run this statement and get weird result in some fields:
update wtMaster
set pFirstName = substring(first_middle, 1, patindex('% [A-Z].', first_middle)),
pMiddleInitial = substring(first_middle, patindex('% [A-Z].', first_middle) + 1, 1)
where first_middle like '% [A-Z].' and pFirstName is null
Some rows get the following result:
"Middle initial parsed from first_middle"
There is data in the first_name field. Any idea why this might happen? Thanks in advance.
April 10, 2003 at 4:47 am
quote:
"Middle initial parsed from first_middle"
If you are getting that as a result then there is data with that in it you are parsing from first_middle.
April 10, 2003 at 10:22 am
No, the data looks fine. I select * from the whole table and the data in first_middle is fine. Thanks.
April 10, 2003 at 1:10 pm
Never mind, the entry was a default value.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply