### ----------------------------------------------------
### -- Red
### -- Licenses: Artistic-2.0
### -- Authors: Fernando Correa de Oliveira
### -- File: docs/api/Red/ColumnMethods.md
### ----------------------------------------------------
Red::ColumnMethods
------------------



Red::Column methods

### method starts-with

```raku
method starts-with(
    Str(Any) $text
) returns Mu
```

Tests if that column value starts with a specific sub-string is usually translated for SQL as `column like 'substr%'`

### method ends-with

```raku
method ends-with(
    Str(Any) $text
) returns Mu
```

Tests if that column value ends with a specific sub-string is usually translated for SQL as `column like '%substr'`

### method contains

```raku
method contains(
    Str(Any) $text
) returns Mu
```

Tests if that column value contains a specific sub-string is usually translated for SQL as `column like %'substr%'`

### method lc

```raku
method lc() returns Mu
```

Return a lowercased string

### method fc

```raku
method fc() returns Mu
```

Return a lowercased string

### method uc

```raku
method uc() returns Mu
```

Return a uppercased string

### method substr

```raku
method substr(
    $offset = Code.new,
    $size?
) returns Mu
```

Return a substring of the column value

### method substr

```raku
method substr(
    $offset = Code.new,
    $size?
) returns Mu
```

Return a substring of the column value

### method index

```raku
method index(
    $needle
) returns Mu
```

Return a index of the column value

### method index

```raku
method index(
    $needle
) returns Mu
```

Return a index of the column value

### method year

```raku
method year() returns Mu
```

Return the year from the date column

### method month

```raku
method month() returns Mu
```

Return the month from the date column

### method day

```raku
method day() returns Mu
```

Return the day from the date column

### method yyyy-mm-dd

```raku
method yyyy-mm-dd() returns Mu
```

Return the date from a datetime, timestamp etc

### method AT-KEY

```raku
method AT-KEY(
    $key where { ... }
) returns Mu
```

Return a value from a json hash key

### method DELETE-KEY

```raku
method DELETE-KEY(
    $key where { ... }
) returns Mu
```

Delete and return a value from a json hash key

### method AT-POS

```raku
method AT-POS(
    $key where { ... }
) returns Mu
```

Returns a value from a json array index



