دستورات String function:

نویسنده :
تاریخ:چهارشنبه 13 دی 1391-08:32 ق.ظ

دستور Left , Right:این دستور نشان دادن تعداد کاراکتر ار سمت چپ یا راست است.

Select

'abcdefg'

LEFT('abcdefg' ,3)

FORM

Students

Select

'abcdefg'

RIGHT('abcdefg' , 2)

FORM

Students

دستور اصلی به این صورت است.و حرف اول از سمت چپ و راست اسامی را نشان می دهد.

مثال:

SELECT

FirstName,

LEFT(FirstName, 1) + ' –' + RIGHT(FirstName, 1)

FoRM

Students

 

دستور LEN:این دستور برای نشان دادن تعداد کاراکتر عبارت رشته ای است.

مثال:

SELECT

FirstName,

LEN(FirstName)

FORM

Students




داغ کن - کلوب دات کام
نظرات() 
Eroxel ¿Dónde Comprarlo
سه شنبه 4 تیر 1398 02:40 ق.ظ
You made some decent points there. I looked on the internet for more information about
the issue and found most individuals will go along
with your views on this site.
http://haravfallse.ovh/
دوشنبه 3 تیر 1398 07:21 ب.ظ
At this time I am going away to do my breakfast, afterward having my breakfast
coming over again to read more news.
http://nonacne-fi.eu
دوشنبه 3 تیر 1398 06:37 ب.ظ
obviously like your web-site however you have to take a look at the spelling
on quite a few of your posts. A number of them are rife with spelling issues and I find it very bothersome to
inform the truth on the other hand I'll surely come back again.
Deseo
دوشنبه 3 تیر 1398 12:35 ب.ظ
It is truly a great and helpful piece of info.
I am satisfied that you just shared this useful information with us.
Please keep us up to date like this. Thank you for sharing.
http://testosteron-tabletki.eu/Testomag.html
دوشنبه 3 تیر 1398 11:37 ق.ظ
That is really attention-grabbing, You're a very professional
blogger. I have joined your rss feed and stay up for
seeking extra of your wonderful post. Additionally,
I've shared your web site in my social networks
http://www.produtos-para-disfuncao-eretil.eu/
دوشنبه 3 تیر 1398 09:47 ق.ظ
Hello! This post could not be written any better! Reading this post reminds
me of my previous room mate! He always kept chatting about this.
I will forward this post to him. Pretty sure he will
have a good read. Thanks for sharing!
http://pillole-per-pene-it.eu/memberxxl.html
شنبه 25 خرداد 1398 11:52 ب.ظ
Hi there! I know this is somewhat off-topic but I needed to ask.
Does managing a well-established website such as yours require a lot
of work? I'm completely new to blogging however I do write in my journal everyday.
I'd like to start a blog so I can share my own experience and thoughts online.
Please let me know if you have any kind of recommendations or tips for
new aspiring bloggers. Appreciate it!
Turbo Max Blue Összetevők
شنبه 25 خرداد 1398 08:25 ب.ظ
An outstanding share! I have just forwarded this onto a co-worker who had been conducting a little research on this.
And he in fact bought me dinner because I found
it for him... lol. So allow me to reword this....
Thanks for the meal!! But yeah, thanx for spending the time to talk
about this issue here on your internet site.
machoman Opinioni
شنبه 25 خرداد 1398 08:10 ب.ظ
I love it whenever people come together and share ideas.
Great blog, keep it up!
http://bantningspillersomverkligenfungerar.ovh/
جمعه 24 خرداد 1398 11:11 ب.ظ
Hi there friends, how is the whole thing, and what you
would like to say concerning this piece of writing, in my view its in fact remarkable in support of me.
http://tabletky-na-rast-penisu-sk.eu/Eroxel.html
جمعه 24 خرداد 1398 07:17 ب.ظ
Fabulous, what a web site it is! This website provides useful information to us,
keep it up.
erozon max
جمعه 24 خرداد 1398 04:28 ب.ظ
you're really a excellent webmaster. The web site loading velocity is incredible.

It kind of feels that you are doing any unique trick.
Furthermore, The contents are masterwork. you have performed a great job in this subject!
tabletki na potencje
جمعه 24 خرداد 1398 02:50 ب.ظ
Hello, all is going sound here and ofcourse every one is sharing data, that's actually excellent, keep up writing.
http://de-beste-testosteronboosters.eu/TestoUltra.html
جمعه 24 خرداد 1398 01:18 ب.ظ
What's up to every one, since I am truly eager of reading this website's post to
be updated regularly. It consists of nice material.
Phallosan Forte
جمعه 24 خرداد 1398 11:26 ق.ظ
It's hard to find knowledgeable people about this topic, however, you sound like you know what you're talking about!

Thanks
pilule amaigrissante
جمعه 24 خرداد 1398 09:10 ق.ظ
Hello this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to
manually code with HTML. I'm starting a blog soon but have no coding
skills so I wanted to get guidance from someone with
experience. Any help would be greatly appreciated!
BeMass
جمعه 24 خرداد 1398 06:53 ق.ظ
I was recommended this web site by way of my cousin. I'm no longer positive whether this post is written by him as nobody else recognise such distinctive about my trouble.
You are amazing! Thanks!
Musculin Active
جمعه 24 خرداد 1398 06:08 ق.ظ
Hi there, I desire to subscribe for this webpage to take newest updates, thus where can i do it please
help out.
Eron Plus Cena
جمعه 24 خرداد 1398 05:33 ق.ظ
Ahaa, its good dialogue concerning this post
here at this website, I have read all that, so now me also commenting
at this place.
Dr Extenda
جمعه 24 خرداد 1398 03:41 ق.ظ
Thank you for every other excellent post. The place else may anybody
get that type of info in such a perfect means of writing?
I have a presentation subsequent week, and I'm at the search for
such information.
member xxl
جمعه 24 خرداد 1398 02:37 ق.ظ
Hello I am so grateful I found your weblog, I really found you by mistake, while I was researching on Google
for something else, Anyhow I am here now and would just like
to say thanks a lot for a tremendous post and a all round interesting blog (I also
love the theme/design), I don't have time to look over it all at the minute but I have saved it and also added in your RSS feeds, so when I have time I will be back to read a great deal more,
Please do keep up the awesome work.
kalkulator brutto-netto
دوشنبه 20 خرداد 1398 01:31 ق.ظ
excellent points altogether, you just won a new reader.
What could you recommend about your submit that you made a few days
ago? Any sure?
kalkulator wynagrodzeń
یکشنبه 19 خرداد 1398 09:11 ب.ظ
Hi there to all, the contents existing at this web page are in fact awesome for people experience, well, keep
up the good work fellows.
kalkulator brutto-netto
یکشنبه 19 خرداد 1398 04:53 ب.ظ
Good post. I learn something new and challenging on blogs I
stumbleupon every day. It will always be useful to
read content from other writers and use something from other sites.
kalkulator brutto-netto
یکشنبه 19 خرداد 1398 12:34 ب.ظ
Simply desire to say your article is as surprising.
The clearness in your post is simply cool and i could assume you're an expert on this
subject. Well with your permission allow me to grab your feed to
keep up to date with forthcoming post. Thanks a million and
please carry on the gratifying work.
kalkulator wynagrodzeń
یکشنبه 19 خرداد 1398 10:17 ق.ظ
Everyone loves what you guys are up too. This type of clever work and reporting!
Keep up the fantastic works guys I've incorporated you guys to my own blogroll.
3400 zł brutto
یکشنبه 19 خرداد 1398 10:06 ق.ظ
Hello Dear, are you actually visiting this web page on a
regular basis, if so afterward you will definitely obtain fastidious experience.
kalkulator brutto-netto
یکشنبه 19 خرداد 1398 09:01 ق.ظ
Hi there, I log on to your new stuff daily. Your story-telling style is witty, keep it up!
3200 zł brutto
یکشنبه 19 خرداد 1398 08:29 ق.ظ
Hey would you mind letting me know which hosting
company you're working with? I've loaded your blog in 3 different
browsers and I must say this blog loads a lot faster then most.
Can you recommend a good internet hosting provider at a honest
price? Thanks, I appreciate it!
kalkulator brutto-netto
یکشنبه 19 خرداد 1398 08:06 ق.ظ
Hi, Neat post. There's a problem along with
your web site in web explorer, could test this? IE nonetheless is the marketplace leader and a large section of other folks will miss your great writing
because of this problem.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر


نمایش نظرات 31 تا 60


Admin Logo
themebox Logo