sqlite上的sqlite子字符串错误现在可以使用它. [英] Sqlite substring error on sqlite now to use it.

问题描述

如何在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 a substr function, you can try that one. Aside from that, SQLite doesn''t appear to have a CHARINDEX function, but instr should do the same job. SQLite Query Language: Core Functions[^]

这篇关于sqlite上的sqlite子字符串错误现在可以使用它.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！