var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Crazy search
Hi everyone -
We are trying to perform a lookup in a varchar column in a table.
The data in the column should be numeric, but it can be
alpha as well (bad spec)
the user can enter a value that will be searched, but they are
lazy (as usual) and don't enter the full number...
The data in the table looks like this
and the user entered 1001
We are running timing tests using the like and right methods
using the assumptions that the right most characters are the correct
but i would like some different opinions or methods