Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Query For Lower Case f Expand / Collapse
Author
Message
Posted Saturday, June 4, 2005 12:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 6, 2012 2:24 PM
Points: 31, Visits: 51
Yes,I got all the filenumber with lowercase 'f' now if i want update them how its possible and what would be the permanent solution so nobady can enter filenumber with lowercase 'f'?
Thanks my friends
Post #187632
Posted Saturday, June 4, 2005 12:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 6, 2012 2:24 PM
Points: 31, Visits: 51
Yes,I got all the filenumber with lowercase 'f' now if i want update them how its possible and what would be the permanent solution so nobady can enter filenumber with lowercase 'f'?
Thanks my friends
Post #187633
Posted Monday, June 6, 2005 8:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
You can always run this query to update the data

Update dbo.YourTable set YourColumn = UPPER(YourColumn)


then I would put an on insert/update and run the same query for that column.
Post #187866
Posted Monday, June 6, 2005 10:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 6, 2012 2:24 PM
Points: 31, Visits: 51
I tried that command and it gives me all the file numbers with small f.If i want to update the filenumber by upper case F,it is going through all the data and updates all the file number as they are already with upper case F.Can you tell me how we can update only the filenumbers with small f by using valbinary clause.
Thanks for your help.
Post #188063
Posted Tuesday, June 7, 2005 6:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
Can you post the table definition of the table (telling which field needs to be updated)? I'll be able to give you the query then.


Also I meant this in my previous post :

then I would put an on insert/update TRIGGER and run the same query for that column.
Post #188157
Posted Wednesday, December 11, 2013 4:30 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 29, 2014 11:34 PM
Points: 790, Visits: 646
Can you check the below code, you can only update which are in Lower case.

DECLARE @tblName TABLE
(
NAME VARCHAR(100),
Action CHAR(1)
)

INSERT INTO @tblName
SELECT '090909f','N'
UNION ALL
SELECT '090909F','N'

Update @tblName SET name = UPPER(name),Action = 'U' where name COLLATE SQL_Latin1_General_CP1_CS_AS = Lower(name)
select * from @tblName where Action = 'U'



Regards,
Mitesh OSwal
+918698619998
Post #1521824
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse