General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have to SELECT from a SQL server table on a field of char. 7
I do my SELECT and say something like this:
l_cSQL = "SELECT *"
l_cSQL = l_cSQL + " FROM Table"
l_cSQL = l_cSQL + " WHERE myfield LIKE '"+ALLT(ThisForm.myProperty) + "%'"
and the value of myProperty is '01'
Now the problem with this is it will retrieve '011' or '0122' or wherever is after that. I don't want that. I only want the value of '01'
What function can I use to do this? Or how can I say that in my SELECT?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only