SQL與法中直接擷取字串的函式使用 substring(原字串, 啟始取值位置, 欲取的字元數)
這裡與DELPHI的Copy用法一摸摸一樣樣~
範例：取g.declno前兩字元
cntc.cntcid = substring(g.declno,1,2)
|
||||||
SQL中擷取字串讀者也會看的其它文章： |
||||||
|
Copyright © 2012 No Money No Honey - All Rights Reserved No Money No Honey is Digg proof thanks to caching by WP Super Cache |
||||||
近期迴響