Use the following code: select *,right(field1,4) as Col1 from [Tablename]order by col1 You can do it by using substring: SELECT *, substring(field1, 3, 5) as col1from [tablename]order by col1
‘*********************************************************************’Text files Reading’You can use Microsoft Text Driver’*********************************************************************Public Function Read_Text_File() As ADODB.Recordset Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim conn As ADODB.Connection Set conn = New ADODB.Connection
This code will do the trick: ABCDEFGHIJKLMNOPQRSTUVWXYZ
If your solution contains a setup project and this setup project has been built at least once, you get an Assembly Load error when you run the Inheritance Picker in
It is possible to use VB6 ActiveX controls – such as ADO Data Control, Chart Control, Comm Control, and the Windowless controls – with the designer of Visual Studio .NET,
When you need a timer for a larger interval than the Timer control allows, insert this code into a BAS module. The procedure starts when the timer interval has passed:
If you have dynamically generated form controls on a Web page, all with the same name, this is a good way to parse out each control’s value and load them