Neither my developer nor I can figure out this one! The package I'm using is "Animal Shelter Manager" and is written in SQL. Every other installation of the product can use the SELECT SUBSTRING command except mine! I use the following code:
SELECT SUBSTRING (AnimalName, 1, 1) FROM Animal and I get "Syntax error or access violation near "(AnimalName, 1,1) FROM Animal" at Line 1." I can use the following with no error, so I know it has to be in the SUBSTRING option: SELECT AnimalName FROM Animal I also get a syntax error when I use an "IF" statement. I get the same error on my home computer (PC) and the PC's at our shelter office. I also get a message at startup that says: "mmtask.exe Unable to locate component. Application has failed to start because mmvcp70.dll was not found. Reinstalling application may fix problem." Don't know if this is related to the substring error or not. I have reinstalled my application and it doesn't help. I think I"m using the current release of SQL but don't know how to check for sure. As you can probably tell, I'm new to SQL. Can anyone help me with this problem? Thanks, Sue in Sequim WA
