Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 927
  • Last Modified:

SQL Statement "SubString" + "Insert Into"

Dear Expert,

I am writing a access program, and would like to using the SQL statement to lookup some of the datas.

Insert Into rawdata(test)
Select SubString(sub_department,2,2) from rawdata

Any one can tell me any problem on it?
Because when i run this statement, error message was pop-up...even i try to change the SubString to SubStr and the problem also exists.

Thanks.

Ricky.
0
Rickyyy
Asked:
Rickyyy
1 Solution
 
BrandonGalderisiCommented:
I believe the access equivalent of substring is mid().

Insert Into rawdata(test)
Select mid(sub_department,2,2) from rawdata
0
 
RickyyyAuthor Commented:
Thanks..
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now