Msg#: 4412980 posted 7:26 am on Feb 1, 2012 (gmt 0)
Hi... I have a table of Kids Church songs containing approximately 200 songs. I'd like to be able to retrieve records alphabetically using the first letter of the songTitle, based on the alphabet in the URL string...
Example : www[dot]examplesite[dot]com/song.php?songIndex=A
I can't seem to get the Select statement correct.
Select * from table where substring(songTitle, 1, 0) = $songIndex order by songTitle