 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
 |
|
 |
 |
 |
 |
 |
 |
 |
|
 |
 |
 |
 |
 |
 |
 |
|
|
|
|
Function
|
��Ժ��
|
��ҷ�����
|
�ŷ�����Ѻ
|
|
Asc( )
|
�ŧ��ҵ���ѡ�������� Asscii
|
Asc("C")
|
67
|
|
Chr( )
|
�ŧ������� Asscii
�繵���ѡ��
|
Chr(66)
|
"B"
|
|
Format( )
|
�ʴ���ҵ�� Format ������ ��. Format
( ��ҷ����� , Format ����ͧ��� )
|
Format (1/2/00 , "dd-mm-yyyy)
|
2-1-2000
|
|
InStr( )
|
������������ ������繵��˹��á��辺
|
InStr("ABCDE", "C")
|
3
|
|
LCase( )
|
�ŧ�繵��������
|
LCase("AbCDe")
|
"abcde"
|
|
UCase( )
|
�ŧ�繵���˭����
|
UCase("AbCDe")
|
"ABCDE"
|
|
Left( )
|
�Ѵ�ӹѺ�ҡ������
|
Left("Test",2)
|
"Te"
|
|
Right( )
|
�Ѵ�ӹѺ�ҡ�����
|
Right("Test",2)
|
"st"
|
|
Mid( )
|
�Ѵ�ӵ�����Ƿ��... �Ѻ���� ....
���
|
Mid("Test",2,2)
|
"es"
|
|
Val( )
|
�ŧ Text �� Number
|
Val("00050")
|
50
|
|
Trim( )
|
�Ѵ��ͧ��ҧ˹����ѧ�͡�
|
Trim(" Test ")
|
"Test"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
