sqlite上的sqlite子字符串错误现在可以使用它. [英] Sqlite substring error on sqlite now to use it.
本文介绍了sqlite上的sqlite子字符串错误现在可以使用它.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在sqlite中使用子字符串,但不是sqlite,但是我需要在sqlite中使用.如何在另一种方法中使用.
How to use substring in sqlite but not is sqlite but i need in sqlite. How to use in another method.
SELECT SUBSTRING(AccountNo, 0, LEN(AccountNo)-(CHARINDEX(''-'', AccountNo) +1)) FROM account
我尝试过的事情:
What I have tried:
SELECT SUBSTRING(AccountNo, 0, LEN(AccountNo)-(CHARINDEX(''-'', AccountNo) +1)) FROM account
它在sql上有效,但在SQLITE上为
错误
it is working on sql but error on SQLITE as
no such function: SUBSTRING:
SELECT SUBSTRING(AccountNo, 0, LEN(AccountNo)-(CHARINDEX(''-'', AccountNo) +1)) FROM account
推荐答案
SQLite具有substr
函数,您可以尝试使用该函数.除此之外,SQLite似乎没有CHARINDEX
函数,但是instr
应该做同样的工作. SQLite查询语言:核心功能 [
SQLite has asubstr
function, you can try that one. Aside from that, SQLite doesn''t appear to have aCHARINDEX
function, butinstr
should do the same job. SQLite Query Language: Core Functions[^]
这篇关于sqlite上的sqlite子字符串错误现在可以使用它.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文