I have enabled Glossary view in Views2, I'm not sure if it's a default view for Views or was added when I installed a certain module, but regardless it is working to show a content type by title as long as the title starts with a letter A through Z. The trouble is I am trying to make another entry in my primary links menu (this is where A through Z appear) that shows clickable links of node titles for a certain type in an unordered list, each node starting with a number 0 through 9. I would like this menu item to be called "#" and would list nodes of a given type with titles like 123Towing Company Inc., 24Hour Towing, 48 Hour Towing Company, etc. which would be similar to how A shows A1 Towing, etc. and Z shows Zebra Towing Company.
Can anyone help me? I don't know if I can do this with a view block/page or just php query in a block somehow? :S
Thanks
-Bill
Comments
Here's a start...
By no means tested...
Look into REGEXP and SQL.
db_query_range(db_rewrite_sql("SELECT n.nid FROM {node} n WHERE n.type='image' AND 'title' REGEXP '[1-9]'"), 0, $count);
Solved here
http://drupal.org/node/673100#comment-2736350
Drupalutvecklare | Drupal Developer in Sweden