How to insert 2 letters in front of Filtered Values

**toci** · 04-08-2016, 06:04 PM

Hi again,

How to put two letters based on Criteria? E.g. in my file I need to put "ZZ" in front of each "BR101A" and "BR101D" in "BR" Column.
Any idea how to do this?

Thanks.

**mrice** · 04-09-2016, 04:40 AM

You could create an update query with the following SQL

Please Login or Register  to view this content.

Remove the xxxxx before use - I needed to put this in as the site would not allow functional SQL to be loaded

**toci** · 04-09-2016, 05:53 PM

Thanks man! This is perfect!

How to insert 2 letters in front of Filtered Values

LinkBack

Thread Tools

Rate This Thread

Display

How to insert 2 letters in front of Filtered Values

Re: How to insert 2 letters in front of Filtered Values

Re: How to insert 2 letters in front of Filtered Values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] remove front letters from numbers

[SOLVED] ID number with 2 letters in front

[SOLVED] Making a Part# List, Sequential Increments with Letters and numbers in front...

Need a minus sign in front of two letters

Increment with letters in front

How to add 2 letters in front a number down a who column

Letters and 000s in front of actual number not sorting correctly

Bookmarks

Bookmarks

Posting Permissions