var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
This is a really basic sorting problem. For some reason I can't figure out how to sort by the First character in a field. For example: Creating a query to select members whose last name begins with the letter "A"
I know this has to be an easy fix, any help???
sorting by the first character of a field is easy -- just ORDER BY the field
selecting members whose last name begins with A is a different question
... where left(lastname,1) = 'A'
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors