Hi all,
I am VFP programmer and looking for operator in MS SQL 2000 that work like $ in foxpro.
For example :
In VFP, I can do like this....
select itemno, description from mytable where class $ "A B C"
There is no direct equivalent of the VFP "$" (contained in)function in T-SQL. Below is an example of something that will give you simliar results.
SELECT itemno, description
FROM mytable
WHERE LEFT(class,1) IN ('A','B'C')
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.