There is an assumption that working with visual basic program means
working with database scope, it's not entirely true. However, the data can be
processed by the visual basic could be internal data and external data.

1.

Function of the operator "

Type:

Example: MsgBox "Learning Visual Basic "

Result: Learning Visual Basic 6 [Start date: 21/03/2012]

2.

This function is used to cut the character, from the

Type:

Example: MsgBox

Result: Ambar

3.

This function is used to cut the character, from the

Type:

Example: MsgBox

Result: halim

4.

This function is used to cut the character, from the

Type:

Example: MsgBox

Result: halim.blog

5.

This function is used to calculate the

Type:

Example: MsgBox

Result: Number of characters is: 23

6. UCase

This function is used to convert all characters to UPPERCASE.

Type:

Example: MsgBox

Result: AMBARHALIM

7.

This function is used to convert all characters to lowercase.

Type:

Example: MsgBox

Result: ambarhalim

8.

This function is used to remove the spaces

Type:

Example: MsgBox "You" &

9.

This function is used to eliminate the

Type:

Example: MsgBox "You" &

10.

This function is used to eliminate the

Type:

Example: MsgBox "You" &

11.

This function is used to convert a

Type:

Example: MsgBox

The

Some functions are reserved for the data of numeric type are:

1.

This function is used to

Type:

Example: MsgBox

2.

This function is

Type: <Number>

Example: [#1] MsgBox 6

Result: [#1] 6, [#2] 3

3.

This function is used to generate absolute numbers.

Type:

Example: MsgBox

4.

This function is used to

Type:

Example: MsgBox

5.

This function is used to add a

Type:

6.

This function is used to c

Type:

7.

This function is used to

Type:

8.

This function is used to

Type:

9.

This function is used to

Type:

10.

This function is used to

Type:

11.

This function is used to

Type:

12.

This function is used to

Type:

13.

This function is used to

Type:

Tumpal Tambunan
Internal data is data that is instantly recognizable by the computer because the
data is stored in computer memory (RAM). While the external data is data that is
stored outside the processing device (Floppy disks, hard disks, CD, tape, USB
and others).

Use of operators and functions on data of characters types

**.**
Data of characters type is the type most frequently used data, where these data
types can be used for data Alphanumeric (Alphabetic and Numeric). So with this
data type you can enter data alphabet, numbers, dates, and other data.

Generally it's said that the data have a character data type when the data is
marked with quotes. All alphabets that displayed on the keyboard is a data type
of character. Some functions are reserved for the data of characters type are:

1.

**&**Function of the operator "

**&**" is to combine the data, either the data of character type, numeric or date and time.Type:

**&**Example: MsgBox "Learning Visual Basic "

**&**6**&**" [Start date: "**&**Date**&**"]"Result: Learning Visual Basic 6 [Start date: 21/03/2012]

2.

**Left**This function is used to cut the character, from the

*left*as many as**N**characters.Type:

**Left**(<String>, N)Example: MsgBox

**Left**("Ambarhalim", 5)Result: Ambar

3.

**Right**This function is used to cut the character, from the

*right*as many as**N**characters.Type:

**Right**(<String>, N)Example: MsgBox

**Right**("Ambarhalim", 5)Result: halim

4.

**Mid**This function is used to cut the character, from the

**P**position as many as**N**characters.Type:

**Mid**(<String>, P, N)Example: MsgBox

**Mid**("Ambarhalim.blogspot.com", 6, 10)Result: halim.blog

5.

**Len**This function is used to calculate the

*number*of characters.Type:

**Len**(<String>)Example: MsgBox

**Len**("Ambarhalim.blogspot.com")Result: Number of characters is: 23

6. UCase

This function is used to convert all characters to UPPERCASE.

Type:

**UCase**(<String>)Example: MsgBox

**UCase**("ambarhalim")Result: AMBARHALIM

7.

**LCase**This function is used to convert all characters to lowercase.

Type:

**LCase**(<String>)Example: MsgBox

**LCase**("AMBARHALIM")Result: ambarhalim

8.

**Trim**This function is used to remove the spaces

*left*and*right*.Type:

**Trim**(<String>)Example: MsgBox "You" &

**Trim**(" And ") & "Me"__Result__: YouAndMe9.

**RTrim**This function is used to eliminate the

*blank space*to the*right*.Type:

**RTrim**(<String>)Example: MsgBox "You" &

**RTrim**(" And ") & "Me"__Result__: You AndMe10.

**LTrim**This function is used to eliminate the

*blank space*to the*left*.Type:

**LTrim**(<String>)Example: MsgBox "You" &

**LTrim**(" And ") & "Me"__Result__: YouAnd Me11.

**Val**This function is used to convert a

*string*into a*numeric value*.Type:

**Val**(<String>)Example: MsgBox

**Val**("1 23 4")__Result__: 1234The

**format**and**function**on*data of numeric type*.*Data of numeric types*are data types that are only used to store or operate the numeric data. With these data types, mathematical calculations can be done well even be done at a very high degree of accuracy. Given a numeric data type is only for the number data, preferably in the use of numeric data is not covered or restricted by quotes ("") for the string or sign (##) for date and time.Some functions are reserved for the data of numeric type are:

1.

**Int**This function is used to

*generate integers*.Type:

**Int**(<Number>)Example: MsgBox

**Int**(4.98)__Result__: 42.

**Mod**This function is

*divides two numbers*and*returns only the remainder*.Type: <Number>

**Mod**<Number>Example: [#1] MsgBox 6

**Mod**9, [#2] MsgBox 9**Mod**6Result: [#1] 6, [#2] 3

3.

**Abs**This function is used to generate absolute numbers.

Type:

**Abs**(<Number>)Example: MsgBox

**Abs**(-4.98)__Result__: 4,984.

**Sqr**This function is used to

*determine the square root.*Type:

**Sqr**(<Number>)Example: MsgBox

**Sqr**(81)__Result__: 95.

**Sum**This function is used to add a

*value of the query*command.Type:

**Sum**(<Field>)__Example of use__: Select**Sum**(Salary) As Total_Salary From Employee6.

**Count**This function is used to c

*alculate the amount of data in the query*command..Type:

**Count**(<Field>)__Example of use__: Select**Count**(Material_Name) As Total From Material7.

**Avg**This function is used to

*calculate the average value of the query*command.Type:

**Avg**(<Field>)__Example of use__: Select**Avg**(Salary) As**Avg**_Salary From Employee8.

**Max**This function is used to

*generate the greatest value of the query*command.Type:

**Max**(<Field>)__Example of use__: Select**Max**(Salary) As Greatest_Salary From Employee9.

**Min**This function is used to

*produce the smallest value of the query*command.Type:

**Min**(<Field>)__Example of use__: Select**Min**(Salary) As Smallest_Salary From Employee10.

**Sin**This function is used to

*generate sine values*.Type:

**Sin**(<Number>)11.

**Cos**This function is used to

*generate the cosine*.Type:

**Cos**(<Number>)12.

**Tan**This function is used to

*generate the tangent*.Type:

**Tan**(<Number>)13.

**Format(,"#,#,##")**This function is used to

*format the display numbers in thousands, millions and so on, as well as a decimal*value.Type:

**Format**(,"#,#,##")__Example of use__:**Format**(5710000,"#,#,##")__Result__: 5.710.000__: Handling various types of data in visual basic 6.0 | visual basic data type__

**Keyword**
**You may also like:**