Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
RTRIM[^] And/Or LTRIM[^] in your SQL statement.Alternatively you could use String.Trim[^]
1. Do not remove spaces from the subname variable during the Form Load event.subname = Module1.sname2. String.Format("%{0}%", "") creates a string parameter that contains %%. Used with the LIKE operator, it will match everything in the database. Please change that line of code to...
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.