تبلیغات
SQL - دستورات String function:

دستورات String function:

نویسنده :tamishan tamishan1
تاریخ:چهارشنبه 13 دی 1391-09: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




داغ کن - کلوب دات کام
نظرات() 
choc
دوشنبه 10 اردیبهشت 1397 02:00 ب.ظ
Have you ever thought about creating an ebook or guest authoring on other blogs?
I have a blog based on the same subjects you discuss and
would love to have you share some stories/information. I know
my subscribers would enjoy your work. If you're even remotely interested, feel
free to shoot me an email.
neryhyland.hatenablog.com
سه شنبه 24 مرداد 1396 01:13 ب.ظ
Somebody necessarily help to make severely posts I might
state. This is the first time I frequented your web page and to
this point? I surprised with the research you made to create this particular publish incredible.
Fantastic process!
What causes pain in the Achilles tendon?
دوشنبه 16 مرداد 1396 05:25 ق.ظ
Normally I don't read article on blogs, but I wish to say that this write-up very
forced me to take a look at and do it! Your writing
taste has been amazed me. Thank you, quite great article.
http://shmusicgilan.mihanblog.com/post/114
شنبه 10 تیر 1396 08:31 ب.ظ
This article is truly a fastidious one it assists new the web people,
who are wishing for blogging.
manicure
یکشنبه 20 فروردین 1396 08:30 ب.ظ
Hi there to every one, the contents existing at this website
are in fact remarkable for people knowledge, well, keep up the good work fellows.
manicure
دوشنبه 14 فروردین 1396 07:55 ب.ظ
Heya! I realize this is sort of off-topic however I needed to ask.
Does running a well-established website like yours require a massive amount work?
I'm completely new to operating a blog however I do write in my diary everyday.

I'd like to start a blog so I can easily share my personal experience and thoughts online.

Please let me know if you have any recommendations or tips for new
aspiring blog owners. Appreciate it!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo