Update Query only for rows "begins with"?

[nstouffer]

In SQL Command is it possible to do this?

Update compcode
Set Seg1 = '28'
Where Company (begins with 'R')???

In VBA, I would say:

Where Left(Company, 1) = 'R'

thanks in advance

 

[bperry]

Two ways:

Update compcode
Set Seg1 = '28'
Where SUBSTRING(Company,1,1) = 'R'

or

Update compcode
Set Seg1 = '28'
Where Company LIKE 'R%'

 

[bperry]

P.S.
If company is indexed, then the LIKE approach might be better than the SUBSTRING. Something tells me that SQL might be more likely to use the index with LIKE, but in fact they might perform exactly the same.

 

[jester777]

This is how you do this with SQL commands

update compcode set Seg1='28' where Company like 'R%'

 

[jasonp45]

You can issue exactly the command you would for VB, using the 'Left' operator. Your command works fine.

Select * from

where Left(Company, 1) = 'R'