S/series

[Fred Slota]

Noticed on "House of Secrets (2nd series)"

probably all over the place.

 

Also, I have now realized that I don't know how to do an advanced find that is case sensitive.

[Steven L. Dasinger]

The following seems to respect the case of the search. It at least works to find ' series)'. Not sure how easy/difficult it is to alter it for general use in Case Sensitive finds.

INSTR(I.Title, ' series)') > 0

Returns 1,572 rows

INSTR(I.Title, ' Series)') > 0

Returns 122,658 rows

INSTR searches the first parameter (I.Title in this example) for the second parameter (' series)' ) and returns either 0 if not found or the number of its position in the first parameter.

Not sure why it works but it appears to.

[Fred Slota]

Thanks.

[Fred Slota]

Well....

 

On the plus side, "House of Secrets (2nd Series)" has capitalized Series on the Title title now.  Thanks.

 

On the minus side, I searched for    INSTR(I.Title, ' series') > 0      and found 1,761 rows (issues, not titles) where you had found 1,572, so it went up...

 

On the, minus side?, several of those I found were "House of Secrets (2nd series)", showing that the search was for the more hidden duplicated issue-by-issue title field and not the primary one-per-title Title field.

 

Searched for    INSTR(ComicTitles.Title, ' series') > 0   and found 480 returns.

 

Astonishing Spider-Man, The (3rd series)

Astonishing Spider-Man, The (4th series)

Atom-Age Combat (2nd series)

Attack (1st series)

Attack (2nd series)

Batgirl (3rd series)

Don Winslow of the Navy (1st series)

Empty Love Stories (2nd series)

Empty Zone (2nd series)

Fantastic Four (Juniorpress, 2nd series)

Fear Diaries (2nd series)

Felix the Cat (1st series)

Felix the Cat (2nd series)

Giant Size Spider-Man (2nd series)

Giant Size Spider-Man (3rd series)

House of Java (2nd series)

Hugo (3rd series)

Joe Palooka (1st series)

Juan Centella (2nd series)

Juggernaut, The (2nd series)

Katy Keene (1st series)

Little Lizzie (2nd series)

Maxwell Mouse Follies (2nd series)

Superman in the Fifties (2nd series)

Terror, Inc. (2nd series)

Universo DC (1st series)

Universo DC (2nd series)

Universo DC (3rd series)

Western Gunfighters (1st series)

 

 

[Fred Slota]

Still found 480 returns, so it looks like no changes made to these titles yet