using this syntax how can I modify it to also give me middle initials.<br>Elsie H Reed<br><br>select firstname = substring(mycolumn , 1, charindex(' ',yourcolumn) -1 ), <br>lastname = ltrim(substring(mycolumn,charindex(' ',mycolumn) + 1, len(mycolumn)- len(substring(mycolumn, 1, charindex('...
can someone pls help me with this syntax.<br><br>BEGIN TRANSACTION tran_Individual_DuesCategory<br><br>UPDATE Individual<br> SET Individual.DuesCategoryID= DuesCategory.DuesCategoryID...
Sorry about the long code, it's is given me error in line 245 incorrect syntax near 'null<br><br>it was working until i added this part<br>select @DuesCategoryID=DuesCategoryID from DuesCategory where DuesCategoryName=@catcde<br>WHILE (@@FETCH_STATUS <>-1)<br>BEGIN<br>select...
We are planning a 3-tier application using VB 6.0, and IIS 4.0. and we<br>would like to use MTS, I will like to how MTS works with VB also what are<br>the advantages and disavantages of placing MTS behind or outside the<br>firewall.<br><br>Thanks,<br>Elsie<br>
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.