Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MID function and SQL Query
Hello!
Is it possible to use MID fiunction in SQL Query? Or is there any other way to get it done.. StrSQL = " SELECT " & _ " j.Accno, SUM(j.db)DR, SUM(j.cr)CR, Month(j.Trdate)Month, LEFT(j.tktno,4)ARL" I would like to get "MID(j.Accno, 5, 3)Loc" three charecters from Accno starting fifth character. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MID function and SQL Query
Use SUBSTRING instead of MID (same syntax)
PS: instead of SUM(j.db)DR write SUM(j.db) AS DR makes t he SQL more readable and closer to the SQL conventions. "Soniya" wrote: Hello! Is it possible to use MID fiunction in SQL Query? Or is there any other way to get it done.. StrSQL = " SELECT " & _ " j.Accno, SUM(j.db)DR, SUM(j.cr)CR, Month(j.Trdate)Month, LEFT(j.tktno,4)ARL" I would like to get "MID(j.Accno, 5, 3)Loc" three charecters from Accno starting fifth character. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MID function and SQL Query
I assumed you are using SQL Server. For Oracle, use SUBSTR. The Excel/Access drivers can use MID. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function query | Excel Programming | |||
query about VALUE function | Excel Worksheet Functions | |||
Function: New Web Query | Links and Linking in Excel | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
mid function in ms query | Excel Discussion (Misc queries) |