Question: How Would I change this function from changing only the letters to change the entire word? I believe I have to change the ch in the code (for ch in newString: ) but I don't know what to.

```
replacements = {
'TOMORROW': 'TMR',
'ABOUT': 'BOUT',
'PLEASE': 'PLZ',
'BEFORE': 'B4'
}

def replace(newString):
old,new = [],[]
for ch in newString:
    if replacements.get(ch):
        newString = newString.replace(ch, replacements.get(ch))
    print(newString)

```

Answer: 
I'm not sure the exact syntax/functions in Snowflake but generally speaking there's a few different ways of achieving this.
I guess the general approach that would work universally is using the SUBSTRING function that's available in any database.

Assuming you have a table called Table1 with the following data:

```
+-------+-----------------------------------------+
  Code  | Desc
+-------+-----------------------------------------+
 0001   | 1First Character Will be Removed
 0002   | xCharacter to be Removed
+-------+-----------------------------------------+

```

The SQL code to remove the first character would be:

```
select SUBSTRING(Desc,2,len(desc)) from Table1

```

Please note that the **"SUBSTRING"** function may vary according to different databases. In Oracle for example the function is **"SUBSTR"**. You just need to find the Snowflake correspondent.

Another approach that would work at least in SQLServer and MySQL would be using the **"RIGHT"** function

```
select RIGHT(Desc,len(Desc) - 1) from Table1

```

Based on your question I assume you actually want to update the actual data within the table. In that case you can use the same function above in an update statement.

```
update Table1 set Desc = SUBSTRING(Desc,2,len(desc))

```
You didn't try this? 

```
UPDATE tableX
   SET columnY = substr(columnY, 2, 10 ) ;

```

-Paul-