Left
Left 英音:[left]美音:[lɛft]
功能得到字元串左部指定個數的字元。
語法Left (string,n)
參數string:string類型,指定要提取子串的字元串n:long類型,指定子串長度返回值String。函式執行成功時返回string字元串左邊n個字元,發生錯誤時返回空字元串("")。如果任何參數的值為NULL,Left()函式返回NULL。如果n的值大於string字元串的長度,那么Left()函式返回整個string字元串,但並不增加其它字元。
例如,在學生課表course中,分別有cno,cname,cpno,credit四列。其中有一項記錄為:1,資料庫,5,4。在SQL分析器中輸入:
INSERT course
(cno,cname,cpno,credit)
select'0001'+left(cno,1),cname,cpno,credit
from course
go
此時course表中會多出一條記錄:00011,資料庫,5,4。
LEFT
根據所指定的字元數,LEFT 返回文本字元串中第一個字元或前幾個字元。
LEFTB 基於所指定的位元組數返回文本字元串中的第一個或前幾個字元。
要點 函式 LEFT 面向使用單位元組字元集 (SBCS) 的語言,而函式 LEFTB 面向使用雙位元組字元集 (DBCS) 的語言。您計算機上的默認語言設定對返回值的影響方式如下:
支持 DBCS 的語言包括日語、中文(簡體)、中文(繁體)以及朝鮮語。
語法
LEFT(text,num_chars)
LEFTB(text,num_bytes)
Text 是包含要提取的字元的文本字元串。
Num_chars 指定要由 LEFT 提取的字元的數量。
Num_bytes 按位元組指定要由 LEFTB 提取的字元的數量。
英語單詞
left
(leave的過去式和過去分詞)
left
形容詞 a.
⒈左方的;左側的[Z][B]
Some people write with their left hand.
有些人用左手寫字。
⒉(常大寫)(政治上)左派的;左翼的
副詞 ad.
⒈在左邊;向左
Walk three blocks and then turn left at the corner.
走過三個街區然後向左轉。
名詞 n.
⒈左,左邊[the S]
John was seated on her left.
約翰坐在她的左邊。
⒉(常大寫)左派;激進分子們[the S][G]
The left oppose the tax increase.
左翼人士反對增稅。
⒊(拳擊中的)左拳[C]
動詞 v.
⒈造成
When this irregular breath hits your voice box,you're left with a big hiccup.
當不規則的氣流撞擊你的喉嚨,就會造成你打一個大大地嗝。
網路釋義
Left
⒈左;左側;左視圖
3DMAX中英文對照(3dmax命令)大全...
Left左;左側;左視圖
⒉跑動方向鍵左
按鍵翻譯(鎖定防守篇) - 〖NBA2K9...
Left 跑動方向鍵左
left
⒈左後衛
left 左後衛
有道詞典
left[left] vt.
leave的變形
left[left] adj.
⒈左的;左邊的;左側的;左手的;左半身的;左方的
⒉左岸的
⒊左翼的;左派的;“左”傾的;急進的;激進的
n.
⒈左邊;左側;左部;[ the left]左方
⒉左側的東西
⒊向左轉;左轉彎
⒋[ the left] 【政治】左派;激進派議員(在歐洲立法機關中常坐在議長席左側,故名)
⒌【軍事】左翼
⒍[美國英語](船的)左舷
adv.
向左邊;在左邊
left[left] leave的過去式和過去分詞
leave[li:v] vt.
1. 離開,離去;從…走開;脫離:例:He has left Beijing for London.
他已經離開北京到倫敦去了。
He left his hometown and looked for a job in town.
他離開家鄉到城裡找工作。
2. 留;剩下:例:She left some of the food for her husband.
她給丈夫留了一些吃的。
3. 留下;將…留下:例:The secretary asked him to leave his telephone number.
秘書要他把電話號碼留下來。
4. (死後或離開後)把…留給;遺贈給:例:His uncle left $10 000 in the will.
他舅舅在遺囑中留下10 000美元。
5. 死後留下;遺留下:例:He left a widow and two children.
他死後撇下寡妻和兩個孩子。
6. 留下;丟下;忘帶:例:I left my dictionary in the library.
我把詞典丟在圖書館裡了。
7. 委託;交託;交由…照管:例:You'd better leave this up to me.
你最好把這件事交給我辦吧。
He left his son to his sister.
他把兒子交由他姐姐照管。
8. 擱置;不管;忽略;暫不解決:例:We'll leave this item till the next meeting.
我們把這個議題放到下次會議討論。
9. 辭去(工作);捨棄;停止;拒絕:例:take it or leave it
取捨悉聽尊便
He left medicine for law.
他放棄醫學改學法律。
10. 剩餘;剩下:例:3 from 7 leaves 4.
7減3餘4。
15 minus 5 leaves 10.
15減5得10。
11. 使…處於(某種狀態);聽任;讓:例:Leave the windows open. It's so stuffy here.
讓窗子開著,這兒太悶熱了。
The earthquake left them homeless.
地震讓他們無家可歸。
12. [方言、俚語]讓;允許:例:Leave them go.
讓他們走。
vi.
離去,離開;出發,動身:例:When we got to the railway station,the train had left.
我們到火車站時,火車已經開走了。
He leaves for work at 7 every morning.
他每天早上7點鐘離家去上班。
變形:
vt.leftleaving
leftn.
⒈location near or direction toward the left side; i.e. the side to the north when a person or object faces eastshe stood on the left
⒉those who support varying degrees of social or political or economic change designed to promote the public welfare
⒊the hand that is on the left side of the bodyjab with your left
⒋the piece of ground in the outfield on the catcher's leftthe batter flied out to left
⒌a turn toward the side of the body that is on the north when the person is facing easttake a left at the corner
adj.
⒈being or located on or directed toward the side of the body to the west when facing northmy left hand left center field the left bank of a river is bank on your left side when you are facing downstream
⒉not used upleftover meatloaf she had a little money left over so she went to a movie some odd dollars left
⒊intended for the left handI rarely lose a left-hand glove
⒋of or belonging to the political or intellectual left
adv.
toward or on the left; also used figurativelyhe looked right and left the political party has moved left
句型
例句展示
⒈
To live in the hearts ofthose left behind is not to die
活在後人心,雖死而猶生
⒉
Mr. Brown racked his Braintrying to remember where he left thewallet.
布朗先生拚命思索,想記起他把錢包放在什麼地方了
⒊
I was left cooling my heels out side your home for twohours
我在你家門外足足等了兩個小時
⒋
They rolled up the moneyand left through the Back gate in a tearinghurry.
他們十分倉促地捲起錢就從後門逃走了
⒌
I believe Mary was left to the tender mercies of her stepmother.
我相信瑪麗受到了後母的虐待
⒍
Who would like tofeel left out at such a function?
在這們的場合上有誰會願意受到冷落呢?
⒎
I let out a parting shotand left
我說了一句氣話就離開了
⒏
Why should I be left holding the Baby alone?
為什麼把這個苦差事留給我一個人乾
⒐
He had nothing left to desire in life
他的生活已經是完美無缺了
⒑
Let not thy left hand know what thy right hand doeth.
不要讓你的左手知道你的右手所做的事(行善不欲人知)。
⒒
George took all the moneyaway and left hiscompanions high and dry,with nothing to Buy the tickets.
喬治帶走了所有的錢,把他的同事拋棄了,連買車票的錢也沒有
⒓
"When someone foundthat the police were coming,he took to his heels and left the others in the lurch"
當有人以現警察來了的時候,他拔腿就跑而對其他的人卻棄之不管了
⒔
"Industry if fortune'sright hand,and frugality her left"
勤勉是幸福的右手,節儉是幸福的左手
⒕
"When I fond that astranger began to make a pass at me,I gave him a stern look and left"
當一個陌生男子開始向我調情時,我瞪了他一眼就離開了
⒖
"From the doorway,hegave a parting shot to his mother andleft"
站在門口,他衝著母親說了一句氣話然後就走了
⒗
He left his gun outside so as not to frighten hiswife.
他把槍放在外面以免驚嚇他的妻子。
⒘
Go down the first turningon the left until you come to a tallbuilding.
在第一條橫馬路左拐彎,然後一直走到一座高樓處。
⒙
Differences of opinionamong committee members cannot be resolved and are left unresolved for a long time
委員間意見分歧的事亦無由解決,並且聽任這些分歧長期地不加解決。
⒚
Turn fight and you will seethe supermarket on your left.
向右拐你就會看到那個超級市場在你左邊。
⒛
I left my belongings with this grand-motherlyfigure and entered into this magnificent hall of learning.
我把我的東西留給那祖母般的工作人員,進入了那宏大的學習之廳。