Hi John,

I mean to say that you have a function called UPPER() in MSSQL to do that you needed, for which I had to give you some example. that
is why I had given it in select statement, so as to give you an idea that MSSQL support converting to upper case. 
>>>>>>>>>>>>>>>>>>>>>>>>
The only fast solution is through the table itself. As far as i know, MS 
Access can convert text to upper case but not MS SQL Server. How can i do 
that
<<<<<<<<<<<<<<<<<<<<<<<<
It is now that you have to figure out where to fit in this. 

I would better suggest you to do such changes in your VB code, you got to just embed the UPPER() function around the TEXT fields
that you refered wherever there is an INSERT or UPDATE statements, which I dont see a bigger issue here. 

If you are not interested in making changes in your VB code then my suggestion is that you can write a trigger for insert and update
for all those tables to update them with upper case values every time they are inserted.

Or 

If you want all the existing data to be converted to upper case then you should use something like this, since you have not given
any clue about the table structure.
Eg: - 
Update Your_Table set Text_Field_Name = UPPER(Text_Field_Name)

it depends if you choose to use the WHERE clause and other stuffs.
__________
Cheers
Vijay G

 John Sek <air_salak@h...> wrote:
Hi Vijay,

I'm updating and inserting into table not selecting from the table. And i 
do not want to modify all the codes done by my seniors because there are 
many forms involved. 

I would be grateful if someone can let me know how to solve this problem.

john

> 
John,

You can use UPPER() function

Select Upper("john") - gives JOHN
Select Upper(Field_Name) from table_Name
_____________
cheers
Vijay G
John Sek wrote:Hi all,

I would like to convert all input to upper case when they are inserted 
into tables. I do not want to do it with vb codes cause there are lots of 
forms involved with these tables.

The only fast solution is through the table itself. As far as i know, MS 
Access can convert text to upper case but not MS SQL Server. How can i do 
that. 

I'm using SQL 2000 DB Server.

Thanks, 

JOhn


---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now