I am developing an application in VB 6.0 which has SQL SERVER which is been migrated from a MS-Access as a database. but in the process the fuctions used are that which are compatable to access and not sql server. How will I make the same application compatable with SQL SERVER?
1] Ability to convert all the queries using Ucase() without using IF-THEN-ELSE statement.
like this query:-
query = "update cus_customer_master set country='" & Address_Module.name_check(cboCountry) & "' where trim(Ucase(country))='" & Trim(Ucase(prev_country)) & "'"
A solution for the above query must work both in Access as well as SQL SERVER.